Before sending an Excel Workbook to someone, it is a good practice to make sure the workbook does not include any errors (e.g. #N/A, #REF!, #NAME?, #DIV/0!, #NULL!, #VALUE! and #NUM!). Although in Excel interface you can search for errors with Go to Special/Find Errors, you can do this only for one sheet at a time. If you want to save time and check all sheets from the workbook, this code is for you!
Please watch the video on my Youtube channel "Data Analytics Central":
https://www.youtube.com/watch?v=O6XO2iU37lU
