I need a macro to report all the (sheet row col) locations of all formula errors such as #N/A, #DIV/0, #VALUE, etc. in a WORKBOOK.
Paul
I need a macro to report all the (sheet row col) locations of all formula errors such as #N/A, #DIV/0, #VALUE, etc. in a WORKBOOK.
Paul
Give this a try:
Please Login or Register to view this content.
Last edited by JBeaucaire; 11-03-2010 at 12:29 PM. Reason: code
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the code. Had to do a minor bug fix:
Please Login or Register to view this content.
Good catch!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks