Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ignoring errors KRK New Users to Excel 2 January 12th 10 12:28 PM
Ignoring #VALUE! errors and MORE!!!!! Romileyrunner1 Excel Worksheet Functions 3 August 26th 09 11:15 AM
SUM ignoring errors Darby Excel Discussion (Misc queries) 2 July 2nd 08 05:29 PM
Ignoring Errors NickHK Excel Programming 0 December 12th 06 02:25 AM
Ignoring reference errors Mike Jerakis Excel Programming 3 January 3rd 06 07:02 PM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"