one way:

Range(Range("A2").Value).Select

another:

ActiveWorkbook.Names(Range("A2").Value).RefersToRa nge.Select


In article ,
"PCLIVE" wrote:

I have this.

Range("Green").Select


"Green" is a define name of a cell range.
If "Green" is also the contents of cell A2, how can I rewrite the Select
statement so that it will refer to the defined name range that is in cell
A2?

Thanks,
Paul