ExcelBanter - A cell reference in a formula changing

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - A cell reference in a formula changing (https://www.excelbanter.com/excel-worksheet-functions/15351-cell-reference-formula-changing.html)

knemitz

A cell reference in a formula changing

How do I keep a cell reference in a formula from changing when a cell is
inserted above it?

Bernie Deitrick

You need to use the INDIRECT worksheet function. For example, to refer to
cell A1 no matter what is inserted above or to the left of the current cell
A1:

=INDIRECT("A1")

HTH,
Bernie
MS Excel MVP

"knemitz" wrote in message
...
How do I keep a cell reference in a formula from changing when a cell is
inserted above it?

All times are GMT +1. The time now is 11:14 PM.