Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ignoring errors | New Users to Excel | |||
Ignoring #VALUE! errors and MORE!!!!! | Excel Worksheet Functions | |||
SUM ignoring errors | Excel Discussion (Misc queries) | |||
Ignoring Errors | Excel Programming | |||
Ignoring reference errors | Excel Programming |