A common mistake when declaring variables in VBA

For today's post I'd like you to imagine that you're an up and coming VBA programmer who is starting to feel at home with the IDE and language.

You've read about some VBA best practices which has made you aware of the benefits of Option Explicit, so you've started to dutifully declare your variables and you try to carefully choose what types they should be.

Good on you, but be warned: you're a prime candidate for falling foul of one of VBA's syntactical nuances!

Also see VBA: What type are your constants?