Weird error
Hi Brad
don't know for sure (someone else around here probably will), but i'm
guessing that as you have Option Explicit you're making not only variable
declarations required but also ensuring that the objects are specified for
the methods or properties and not leaving it "to chance" (although help
doesn't say this!)
Regards
julieD
"Brad K." wrote in message
...
Thanks all for the help. This did the trick.
Out of curiousity, why does one need to put "Application." in this
instance.
Thanks,
Brad
"JulieD" wrote:
Hi Brad
Application.ScreenUpdating = False
will work.
Cheers
JulieD
"Brad K." wrote in message
...
I am getting the following error and I have no clue why:
Compiler error: Variable not defined
The error is showing up on:
Option Explicit
ScreenUpdating = False
(rest of the code deleted...)
What's the deal?
Thanks in advance,
Brad K
|