RANGE addresses. Getting from other cells.

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

 

[Jarek Kujawa]

use

Range("AA1:AE1").Select

 

[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)

 

[thomas]

Thank you all.



Thomas