How do I keep a formula from changing if a row is added or delete.
 

I have a formulas referencing cells in another worksheet. When rows are
added or deleted from the worksheet the formulas are either changed to skip
the new row or receive an #REF! error when a row is deleted. Regardless of
what happens in the worksheet I want the formulas to remain the same

=INDIRECT("Sheet2!A1")

HTH. Best wishes Harald

"cwolterman" skrev i melding
...
I have a formulas referencing cells in another worksheet. When rows are
added or deleted from the worksheet the formulas are either changed to
skip
the new row or receive an #REF! error when a row is deleted. Regardless
of
what happens in the worksheet I want the formulas to remain the same