Indirect addressing

[Ken Rock]

Hi,
I want to put a value into a cell pointed to by data in another cell.
For example, assume cell D5 contains "C4" and I want to put "@@@@" into
cell C4 by using VBA code referring to the contents of D5.
I can apply the 'Indirect' approach when I use the Excel 2003 Worksheet
Lookup Functions but what do I use in VBA?
Thanks in advance,
Ken Rock

 

[abcd]

CHECK: you want to write in a cell known by its name (and this name is
given into an other cell, D5 in your example)

since you are sure the content of D5 is a cell name,
you may use : Range(Range("D5").value)

 

[ken rock]

Many thanks for your prompt response.
It's just what I wanted!
Ken Rock


*** Sent via Developersdex http://www.developersdex.com ***