View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dimitris Dimitris is offline
external usenet poster
 
Posts: 1
Default Trace errant formula to stop annoying message



Hello Charlie,

Thanx for the macro! It worked for me too
I had a huge spreadsheet and when there were no data, some cells were
dividing with 0.

However, after I fixed everything there is still a minor problem. I run
the macro and nothing appears, which means that everything works fine.
When I enter data and then delete them, the irritating message pops up
again!
The macro does not find any invalid cells, so I guess it's Microsoft's
problem....

Anyway, thanx for the macro again!

Dimitris

*** Sent via Developersdex http://www.developersdex.com ***