The REF error upon removing interdependent row

  • Thread starter Thread starter geezaflip
  • Start date Start date
G

geezaflip

I set up a set of equations across several rows of data that made the rows
have precedents and dependents of each other.

I want to delete certain rows that do not fit into the rest of the data
stream, which I cannot tell until I run all the formulas. But when I do
that, I get a lot of REF errors because they are looking for the removed
rows.

How do I avoid this problem?
 
Don't remove those rows???

Or convert your formulas to values (edit|copy, edit|paste special|values) before
you delete those rows???
 
Back
Top