Do you use Option Explicit at the top of your module?

VBA will automaticly instantiate a variable  type=variant for you if
you leave out the Dim. When you 'compile' though, if Option Explicit
is there it will tell you that the variable isn't defined... hasn't
got a Dim... otherwise it just goes ahead and works with the variant.