Lower case "a" in "application"

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
 
J

JE McGimpsey

Do you have 'application' defined as a variable or procedure in your
project? That will override the default case.
 
D

Dave Peterson

Try this anywhere in your code:

Dim Application
(and hit enter)
Then delete that line
 
O

Otto Moehrbach

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
 
O

Otto Moehrbach

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
 
D

Dave Peterson

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>.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top