Macro Errors

A collection of 5 posts

How To Use VBA Debugging In Excel

This example teaches you how to debug code in Excel VBA. Single Step By pressing F8, you can single step through your code. The is very useful because it allows you to see
23 October 2020

How To Use VBA Handling Error In Excel

Below we will look at two programs in Excel VBA. One program simply ignores errors. The other program continues execution at a specified line upon hitting an error. Situation: Both programs calculate the
21 October 2020

How To Use Excel VBA Error Handling

If you are not familiar with Error Handling yet, we highly recommend you to read this example first. When an error in Excel VBA occurs, the properties of the Err object are filled
21 October 2020