ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Range when selected goes to lowercase (https://www.excelbanter.com/excel-programming/418131-range-when-selected-goes-lowercase.html)

tfurness

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



Dave Peterson

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

tfurness

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





All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com