![]() |
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 |
All times are GMT +1. The time now is 05:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com