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." <BradK@discussions.microsoft.com> wrote in message
> news:DDE10552-28A1-4B28-90AF-19A53BF2E778@microsoft.com...
> >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
>
>
>
Bookmarks