| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lower case letter "i" always converts to upper case | Excel Discussion (Misc queries) | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| how do I count only lower case "x" and exclude upper case "X" | Excel Worksheet Functions | |||
Hybrid Mode
