C
CuriousMark
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
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