This post shows a simple technique that will vastly reduce the number of errors in your VBA code.
The simple technique is the Assertion statement. It is simple to use and implement and will provide dramatic results. However don't be fooled by the simplicity of
Debug.Assert. Used correctly it is an incredibly powerful way of detecting errors in your code.
Full article: How to reduce VBA errors by up to 70%