cjindenver
New Member
- Joined
- Jun 3, 2014
- Messages
- 4
I have about 100 reports that I have to run every day, and they are automated using excel macros. There are a few that are extremely visible to decision makers in my company, and I want to find a way to quickly search the entire report for broken or errored formulas or cell values (#REF, #DIV/0!, etc.) before sending out the report. Some of the files are 10-18 MB, and I am trying to find the most efficient way to find any such errors. I could loop through every cell in the used range of each sheet of each report, but that would take forever. Is there a better way to accomplish this task in VBA that I have somehow been missing? I'm picturing a function that can be used to determine if there are errors anywhere in the report, and then I could use the result (true/false) to send an error notice email. Thanks in advance!