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.

use

Range("AA1:AE1").Select

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.

Thank you all.



Thomas