Range(Range("A1").Value).Select

Regards

Trevor


"blitzn" wrote in message
...
I would like my macro to selelct a cell referenced by another cell. For
example the value of a formula in A1 is (so cell A1 reads "C4") so i
would
like to find a way to automatically (macro or VB code) that will select
the
refrenced cell C4.

Any help is much appreciated.