Indirect equivalent in VBA code

[Ken Rock]

Hi,
I have a query about the VBA code equivalent of the Indirect function
and I notice that it already has been answered on 16/09/05 by Bernie
Deitrick. Unfortunately, I cannot access his reply - the page goes blank.
I need to send data to a cell, say C22, by referring to, say, cell E22.
E22 contains the data "C22". This has to be done using VBA.
I hope somebody can help me.
Regards, Ken Rock

 

[Norman Jones]

Hi Ken,

Try:

Range(Range("E2").Value).Value = "My Value"

 

[Ken Rock]

Hi Ken,

Try:

Range(Range("E2").Value).Value = "My Value"

Hi Norman,
Hole in One!
Many thanks
Ken Rock