Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird error
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird error
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird error
Brad K...
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 Hi Brad, Wild guess... Option Explicit Sub WildThang() Application.ScreenUpdating = False Rest of your code... End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weird error
Brad,
You need to add "Application.(dot)" before S"creenUpdating = False" See Application.ScreenUpdating = False And the code should be placed inside of a Sub like this. Sub Test() Application.ScreenUpdating = False 'Your Code Here End Sub -- Regards, Colo http://www.puremis.net/excel/ "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird Arithmetic Error | Excel Discussion (Misc queries) | |||
Very weird error | Excel Worksheet Functions | |||
Weird | New Users to Excel | |||
vlookup weird error | Excel Worksheet Functions | |||
Weird error messages | Excel Discussion (Misc queries) |