Excel VBA: Dealing with Excel Errors (N/A, VALUE!, DIV/0, NAME?, REF!, NULL!, NUM!)

Excel Errors such as #N/A are annoying to deal with. And we can't read the cell value directly from VBA. This video explores different ways to help identify such errors. #vba #learnvba #excelvba #excel #exceltutorial #exceltips An incorrect formula in Excel can display an error value in Excel. These can be #N/A, #VALUE!, #DIV/0, #NAME?, #REF!, #NULL!, #NUM!. Trying to loop over data with errors and attempting to read the cell value, will throw an error in VBA. To avoid this, we would need to check whether there exists an error in a cell, and then, either deal with the error or skip it and move on with our code. We can check for errors using IS functions (ISNA, ISERROR etc.).  We don't need to loop over the entire dataset to check for errors. Using SpecialCells, we can directly check whether there exists any errors across our dataset. And we can go a step further, and identify what type of error exists in a cell using CVErr() function.  Full Code can be found at: https://skillsandautomation.com/useful-code/excel-vba-dealing-with-excel-errors/ 00:00 Intro 01:20 Dealing with Errors in Excel 04:28 VBA - Loop and Identify Errors 08:01 SpecialCells - Identify all Errors 14:10 Distinguish Errors using CVErr()