Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range when selected goes to lowercase
When I use the Application.Range object
the word Range goes to lowercase. What does this mean? It is uppercase when I select it. Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range when selected goes to lowercase
If you created a variable that was lower case, then the VBE will remember this.
Try this: Find an empty spot in your code and add this line: dim Range as Range Hit enter Now delete this line Then test it. tfurness wrote: When I use the Application.Range object the word Range goes to lowercase. What does this mean? It is uppercase when I select it. Thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range when selected goes to lowercase
Exactly... Thank you so much
"Dave Peterson" wrote in message ... If you created a variable that was lower case, then the VBE will remember this. Try this: Find an empty spot in your code and add this line: dim Range as Range Hit enter Now delete this line Then test it. tfurness wrote: When I use the Application.Range object the word Range goes to lowercase. What does this mean? It is uppercase when I select it. Thanks in advance -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
Get Name of Selected Range | Excel Programming | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Box around selected range | Excel Programming |