Inserting Calculated Address as Text into Another Function

[glessens]

After finding the address of certain cells, say A10 and A37 I want to make that my array - A10:A37 so I can insert that into another function.

For example =ADDRESS(MATCH("$$",A10:A37,0),1,1).

How do I make the A10:A37 array a variable so that it will return a value or cell?

I am an expert LOTUS 1-2-3 user and I am at a loss as to how to interpret a LOTUS @STRING function as an EXCEL TEXT string.

[AndyLitch]

The syntax in VBA is...................... Range("A" & X & ":A" & Y)
Where X and Y are the variable row numbers

[azumi]

19-06-2013 14-01-52.png

This might be help