Specifying cell reference relative to active cell

  • Thread starter Thread starter DeepDarkThought
  • Start date Start date
D

DeepDarkThought

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
 
Hi,

Take a look at the OFFSET worksheet function.

Best Regards,
Walt
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Problem with a loop and column references 27
Import multiple workbooks to current workbook in specified row number 0
Array with many cells from a row but not in order or together 11
Combine three InputBoxes into one? 7
Insert Row also adds formulas and moves cursor 2
Relative cell position in VBA 2
Excel VBA 1

Back
Top