Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - Visual Basic
I'm trying to use the EXCEL function, MIN in a macro. I use the exact syntax from HELP but it still errs. The syntax I'm using is, myValue = MIN(B59:B71) The error I get is, "Compile Error, Expected: list separator or )". Can anybody help?- rambob
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Defining a Range in Excel
I am running Excel 97 and am getting an error when I try to define a range using the following statement: Set range1 = Worksheets("Testing divisions").Cells.Range(2, 1, 10, 5) I saw this method referenced at another help site. I need to define a range using row and column defined as...- rambob
- Thread
- Replies: 8
- Forum: Microsoft: Office
-
Micorsoft Excel
I'm sure this is simple but I can't seem to be able to find the way in Excel to retrieve a cell value. I continue to get a type mismatch error (I'm using a macro) with the following: Dim cell cell = Worksheets("Sheet1").Range("E25").Value- rambob
- Thread
- Replies: 3
- Forum: Microsoft: Office
