| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to check and report any formula returned error (eg: #REF!)
I need a sub to run a quick check through a list of sheets (using their
codenames) filled with a ton of formulae, and pop up an all clear msg if there are no errors (eg: #REF!) returned in any formula cell. If there are errors, msg will list the affected codenames. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| different values shown when #DIV/0! error is returned as result | Excel Discussion (Misc queries) | |||
| VALUE ERROR RETURNED FROM FORMULA | Excel Worksheet Functions | |||
| error handling-need to get rid of a value returned as #N/A | Excel Worksheet Functions | |||
| adding cells that contain formulas that have returned error messag | Excel Worksheet Functions | |||
| Error being returned | Excel Worksheet Functions | |||
Threaded Mode
