Re: Why is Option Explicit optional?
I'm a self taught VBA coder and when I first started it was hard enough fixing errors when Option Explicit wasn't in use. There was the occasional typo of my own doing, but it was mainly trying to figure out what all the different Dim declarations actually meant. ie, Long for numbers, Double for really big numbers etc etc. I often used to get them wrong or mix them up & many a time I thought of saying "to h*** with it" & use Variant for everything. Eventually it all sank in & now I use Option Explicit by default, it makes life so much easier, but not understanding the basics like ranges, objects etc made debugging a nightmare for me