ExcelBanter - Cell reference

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Cell reference (https://www.excelbanter.com/new-users-excel/107180-cell-reference.html)

blitzn

Cell reference

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.

Trevor Shuttleworth

Cell reference

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.

All times are GMT +1. The time now is 09:16 PM.