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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top