Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign relative cell reference to variable
Hi,
I have loop in which I want to assign the address (A1 format) of th cell 1 row below the active cell (which naturally changes during th loop) to variable, so that I can use the variable for reference i ACTIVEWORKBOOK.NAMES.ADD. Tried various things, but seem to be going round in circles. I am sur there must be an easy way. Thanks in advanc -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro relative cell reference | Excel Worksheet Functions | |||
Relative cell reference | Excel Discussion (Misc queries) | |||
Relative Cell Reference | Excel Worksheet Functions | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions |