View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz[_2_] Maury Markowitz[_2_] is offline
external usenet poster
 
Posts: 119
Default Ignoring errors?

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