View Single Post
  #1   Report Post  
cwolt
 
Posts: n/a
Default 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.