Specifying cell reference relative to active cell
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 |
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 . |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com