Lower case "a" in "application"

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
O

Otto Moehrbach

Excel XP & Win XP
This is a minor problem, I think, but I have never seen this happen before.
When I use any of the following or when I use "application" when using a
worksheet function in VBA, the leading "a" is lower case. Even when I
manually change it to upper case, Excel will change it back to lower case.
Before now, Excel has always made it upper case regardless of what case I
used.
My question: Why is this? Thanks for your time. Otto
application.ScreenUpdating = False
application.EnableEvents = False
application.DisplayAlerts = False
 
Do you have 'application' defined as a variable or procedure in your
project? That will override the default case.
 
Try this anywhere in your code:

Dim Application
(and hit enter)
Then delete that line
 
JE
I did a Find on the entire project for "application" and found no
instances where it's used as a variable or procedure. Thanks for your time.
Otto
 
Dave
That did it. I don't know how this happened since I am careful to never
use a VBA key word as a variable or procedure name. Thanks for your time.
Otto
 
There's one of those reserved words that's the wrong case for me (still). It
doesn't bother me any more.

Someday, you'll lower your standards <vbg>.
 
Back
Top