Watch me argue it out with the wise and venerable (but ultimately incorrect) Bill “Mr. Excel” Jelen on the topic of using Option Explicit in your code. I argue for the affirmative (that you should use it) while Bill takes the status quo. Let me know your thoughts.
Tags
optionexplicitvba
Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side
With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Jordan, I’m with you on Option Explicit. It makes you think about the code you write. You had that Mr Excel on the ropes, although I’m not sure he realised it at the time!
Option Explicit and declaring my variable properly (with data type) allows me to use Ctrl+ to autocomplete all my variable by typing 3 or 4 characters!
So Jordan, keep on Option Expliciting!!!!
Daniel