ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application object missing? (https://www.excelbanter.com/excel-programming/391896-application-object-missing.html)

Pflugs

Application object missing?
 
I tried to run some code containing "Application.ScreenUpdating = False", and
the editor returned a complier error and said that ".ScreenUpdating - method
or data member not found."

Shouldn't Application point to the Excel application? Where is it? I even
tried declaring an Application object and assigning the Excel application to
it, but that didn't work.

What's wrong? Thanks.
Pflugs

Pflugs

Application object missing?
 
Never mind, I found it. I had accidentally named a userform "Application."

Sorry.

"Pflugs" wrote:

I tried to run some code containing "Application.ScreenUpdating = False", and
the editor returned a complier error and said that ".ScreenUpdating - method
or data member not found."

Shouldn't Application point to the Excel application? Where is it? I even
tried declaring an Application object and assigning the Excel application to
it, but that didn't work.

What's wrong? Thanks.
Pflugs



All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com