When coding, it's easy to make small mistakes. Usually these types of mistakes have no direct effect; the code runs and everything appears to be OK. That makes this situation so dangerous. If you want to gain a quick overview of potential errors, you can use the free TM VBA Inspector. This add-in lets you browse the entire VBA code of an application for potential errors.
Because there're different views about what constitutes an error and what not, you can toggle every single failure in the Options dialog to fine-tune TM VBA Inspector to your individual needs and your own coding style. TM VBA Inspector provides: Detailed list of all "errors" found in VBA code; By double clicking on an "error" you jump to corresponding line in VBA code; Your settings in Options dialog box determine which errors will be reported; How to install TM VBA-Inspector?
Download: TM VBA-Inspector