View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] markjerz@googlemail.com is offline
external usenet poster
 
Posts: 10
Default Newbie vba ranges

Basically I have a cell named "Cell" for convenience. Now that cell
contains a value saying "A1" but this value can change but always
refers to another cell. I want to get the referring cell as a range.
Currently I have:

Dim cell As Range
cell = Range(Range("Cell").Value)

but this doesn't work for some reason.

Can someone please emlighten me?

Thanks,
Mark