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
|