RANGE addresses. Getting from other cells.

  • Thread starter Thread starter thomas
  • Start date Start date
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.
 
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)
 
Back
Top