View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default Selecting a defined Name via a cell's contents

It appears to work in Excel 2000 as well.

Thank you.
Paul


"Toppers" wrote in message
...
Range(Range("A2")).select works in XL2003

"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