Weird error
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
|