Why You Should Use Option Explicit In Excel VBA

In this video I explain the benefits of Option Explicit and why you should enable this for your macros. About By default, Excel VBA does not require data type declarations for variables, however by adding the "Option Explicit" statement to the top of a module, VBA will require you to declare each variable in that module before it can be used. But why create more work for yourself? Watch this video to find out. Excel Version Recorded using Excel Pro Plus 2021 but also works with Microsoft 365 You cannot run VBA/Macros directly in Excel online Excel Tips Playlist    • EXCEL TIPS