ExcelBanter - How do I keep a formula from changing if a row is added or deleted

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I keep a formula from changing if a row is added or deleted (https://www.excelbanter.com/excel-discussion-misc-queries/2572-how-do-i-keep-formula-changing-if-row-added-deleted.html)

cwolt

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

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.

Frank Kabel

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

cwolt wrote:
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.

All times are GMT +1. The time now is 06:31 PM.