Check if the Excel file contain error

[TPortsmouth]

Hello Excel expert,

I am trying to build a startup VBA to check if the current worksheet contain any error as below:

#VALUE !
#DIV/0!
#N/A

This VBA will check which cells contain above error and would prompt a msgbox to show info like below:

Total 10 errors found!
Cell A1, A3, B3 contain #VALUE ! error.
Cell A1, A3, B3 contain #DIV/0! error.
Cell A1, A3, B3 contain #N/A! error.
​

Where the red highlighted text are variables.

Do you have any clue for this? Thanks in advance.

Regards,

TPortsmouth

 

[TPortsmouth]

Hi PatOBrien198,

Thank you so much. You code is amazing! It's working perfectly fine!

P.S. If you have time, please have a look on my other VBA issue, still waiting for some expert's help.

https://www.mrexcel.com/forum/excel-questions/1020776-using-vba-compress-pictures.html

Have a nice day.

TPortsmouth