Ignoring errors?

M

Maury Markowitz

I loop over rows on my long spreadsheet and insert formulas into empty
cells totaling up the numbers below it. However, this makes Excel turn
on all the "Inconsistent Formula" errors and sprinkles the little
green triangles all over the place.

Is there a way to turn this off in code? I really don't want to have
to go to dozens of machines and change the settings!

It would be especially nice if I could do this with a Range.

Maury
 

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

Top