How can I select a cell reference inside a cell in VBA?

[redheadclay]

OK, this is a bit difficult to explain. I want to select the specified range in a cell, not the cell itself. I have:

Range("q3").Select

The cell "q3" has a volatile cell reference IN it (AM23).

I want to select the "AM23", not the "Q3".


Is that clear? I am sure this is simple to do, but I havent quite got it.

Thanks!!!

 

[Tom Urtis]

Range(Range("q3").Text).Select

 

[redheadclay]

YOU are the MAN!!! OH, Thank you very much!!