Indirect addressing

K

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
 
A

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change cell color depending on two cell values 1
Copy/Paste Template to New Workbook 11
= cell above last entered data 8
Show cell contents depending on other cells information 7
INDIRECT Syntax 1
Indirect equivalent in VBA code 2
INDIRECT informulas 1
data lookup/validation syntax 2

Top