Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Indirect" reference to a cell in a code: how to do it?
Hi all, I am trying to build a line of code with the equivalent of the norma INDIRECT function -for example INDIRECT("a1") - how can i do it? Basically, whats the correct way to codify the INDIRECT of Range("a1" in a line of code? Many thanks B -- bondcras ----------------------------------------------------------------------- bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099 View this thread: http://www.excelforum.com/showthread.php?threadid=46822 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Indirect" reference to a cell in a code: how to do it?
Range can take a string value, so it can be used the same as indirect, as long as the string is a
valid address of a cell or range of cells. So if you wanted the same as =INDIRECT("a1") then =Range("A1").Value or, if the text "A1" is in cell B1, for example =Range(Range("B1").Value).Value HTH, Bernie MS Excel MVP "bondcrash" wrote in message ... Hi all, I am trying to build a line of code with the equivalent of the normal INDIRECT function -for example INDIRECT("a1") - how can i do it? Basically, whats the correct way to codify the INDIRECT of Range("a1") in a line of code? Many thanks BC -- bondcrash ------------------------------------------------------------------------ bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997 View this thread: http://www.excelforum.com/showthread...hreadid=468226 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"indirect" cell ref change.... | Excel Discussion (Misc queries) | |||
"indirect" formula reference | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Excel VBA - go to worksheet "name" based on a cell reference ="Name" | Excel Programming |