Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect addressing
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect addressing
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect addressing
Many thanks for your prompt response. It's just what I wanted! Ken Rock *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect addressing for linked file | Excel Worksheet Functions | |||
Graphs using indirect addressing | Charts and Charting in Excel | |||
Indirect Addressing in VBA | Excel Discussion (Misc queries) | |||
Indirect Addressing | Excel Discussion (Misc queries) | |||
Indirect addressing | Excel Programming |