| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to find and log all formula errors on all sheets
Is there a code that goes thru each sheet of the work book and looks for
formula errors (any type) and then record the name of the file and type of error into a different workbook? I have a workbook that has a list of paths to lots of other workbooks, in this workbook I want to create a macro that open each and everyone of those workbooks listed and look for any type of formula errors (i.e.: #VALUE or #DIV/O, or #N/A etc€¦) in them. Your help is greatly appreciated, Adnan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I find duplicate information on 2 sheets using a formula? | Excel Discussion (Misc queries) | |||
| Macro - 2 Sheets - Find/Insert/Copy/Paste | Excel Programming | |||
| FIND AND REPLACE DATA BETWEEN TWO EXCEL SHEETS USING FORMULA | Excel Discussion (Misc queries) | |||
| Stopping errors when a find statement doesn't find! | Excel Programming | |||
| add-in macro strange errors--method sheets of object workbook fail | Excel Programming | |||
Threaded Mode
