Newbie vba ranges
It is even a better idea to not use terms like Range, Cell, Sheet or
Worksheet for names of cells, sheets or workbooks at all and to always modify
them with extra characters when using them as variables.
" wrote:
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
|