How do I keep a cell reference in a formula from changing when a cell is inserted above it?
K knemitz Feb 28, 2005 #1 How do I keep a cell reference in a formula from changing when a cell is inserted above it?
B Bernie Deitrick Feb 28, 2005 #2 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
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
