Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference cells related to the current cell
In a function, how do I reference values in cells offset from the current
cell? For example, I want to concatenate the text in the cells in the two rows above the cell with the function call. Note that the cell containing the function is not necessarily the active cell, so I can't use Activecell to determine it's row/column. I also haven't been able to figure out how to use the Offset function to retrieve the information without also using Activecell. I'm sure this is easy but I just haven't been able to get it. Thanks in advance. CM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click a cell and all related cells are colour highlighted | Excel Worksheet Functions | |||
How to reference the current total, when it could be Cell H9 or H2 | Excel Discussion (Misc queries) | |||
Relative/Current Cell Reference in Hyperlinks | Excel Discussion (Misc queries) | |||
Relative reference to current cell? | Excel Programming | |||
Reference of current cell | Excel Discussion (Misc queries) |