Thread: Weird error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Weird error

ScreenUpdating is a property of the Application object, not the
workbook.
The Application has other properties such as Calculation etc.

Press F2 while in the VBE and you can browse the Application's
Properties and Methods

Tim



"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