Indirect equivalent in VBA code
 

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

Indirect equivalent in VBA code
 

Hi Ken,

Try:

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

---
Regards,
Norman



"Ken Rock" wrote in message
...
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

Indirect equivalent in VBA code
 

Norman Jones wrote:
Hi Ken,

Try:

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

---
Regards,
Norman



"Ken Rock" wrote in message
...

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




Hi Norman,
Hole in One!
Many thanks
Ken Rock