keep formulareferenses when adding columns or rows

  • Thread starter Thread starter vito
  • Start date Start date
V

vito

I wonder if it's possible to keep referenses in a formula when I'm adding a
column or a row?
Greatful for a answer
 
Probably you should use absolute references like $A$1 instead of relative
ones like A1.
Stefi


„vito†ezt írta:
 
This doesn't help because when you are adding a column the referenses change
in the formula whether its absolut or relative referenses.
 
Then use INDIRECT(ADDRESS()) structure, e.g.
=INDIRECT(ADDRESS(1,4,4,1))
shall always refer to D1.
Stefi


„vito†ezt írta:
 
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

cell reference 1
Excel Help to copy information from one row at a time to another sheet 1
VBA - retrieve data on last create named range from previous inserted named range 0
Keep Running Tab 3
Formulas - SUM 4
Having Blank Cells, etc. ? 1
counting blank cells within two columns 2
Excel Moving data to sheet2 from sheet1 0

Back
Top