Lower case "a" in "application"
 

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

Lower case "a" in "application"
 

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

In article ,
"Otto Moehrbach" wrote:

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

Lower case "a" in "application"
 

Try this anywhere in your code:

Dim Application
(and hit enter)
Then delete that line


Otto Moehrbach wrote:

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

--

Dave Peterson

Lower case "a" in "application"
 

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
"JE McGimpsey" wrote in message
...
Do you have 'application' defined as a variable or procedure in your
project? That will override the default case.

In article ,
"Otto Moehrbach" wrote:

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

Lower case "a" in "application"
 

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
"Dave Peterson" wrote in message
...
Try this anywhere in your code:

Dim Application
(and hit enter)
Then delete that line


Otto Moehrbach wrote:

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

--

Dave Peterson

Lower case "a" in "application"
 

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.

Otto Moehrbach wrote:

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
"Dave Peterson" wrote in message
...
Try this anywhere in your code:

Dim Application
(and hit enter)
Then delete that line


Otto Moehrbach wrote:

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

--

Dave Peterson

--

Dave Peterson