RANGE addresses. Getting from other cells.
 

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.

RANGE addresses. Getting from other cells.
 

use

Range("AA1:AE1").Select

RANGE addresses. Getting from other cells.
 

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" wrote in message
...
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.

RANGE addresses. Getting from other cells.
 

Thank you all.



Thomas