Search results for query: *

Acron, Thanks very much...that worked like a charm!

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?

Thanks very much guys...both of these work well. I really appreciate your time and responses.

Skip, What I found in the other help site was that you could define a range by the (beginning row, beginning column, for howm many rows, for how many columns). So, in my original example, I would define a range from A2 to E5 (starting at 2nd row, first column for 10 rows and 5 columns). I...

This is in a macro so can't use menuing or manual commands.

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...

Thanks for the responses. It turns out it was a different statement causing the error...this one seems to work OK. Thanks again.

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