Thread: Weird error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Brad K. Brad K. is offline
external usenet poster
 
Posts: 41
Default 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