Range when selected goes to lowercase

[tfurness]

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]

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]

Exactly... Thank you so much

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.