RANGE addresses. Getting from other cells.

T

thomas

The two addresses in my Range exist as values in two other cells, say AA1 and
AE1.
Cell AA1 contains $A$597 and AE1 contains $O$597.

But my function "Range(AA1:AE1).Select" is erronous.
 
B

Bob Phillips

Range(Range("A1").Value & ":" & Range("E1").Value).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top