Specifying cell reference relative to active cell
Hi,
Take a look at the OFFSET worksheet function.
Best Regards,
Walt
-----Original Message-----
Can anyone tell me how to specify a range with references
relative to the
active cell, so that if I copy or extend a formula into
another cell, the
range used in the formula is always from, e.g. row 2 to 2
rows above the
active cell, and the currnet colum to 2 columns to its
right.
In other words how do you refer to a cell in relative
terms to the current
column and row numbers - Excel doesn't seem to accept
cell references like
COLUMN(),ROW()-2
Or does it?
Thanks
.
|