VBA editor replaces 'Range' with 'range'

UPDATE

What prob. caused it was that I defined the name of a Property
method to be 'range'.

I've removed that and changed every other 'range' and there's
no sign of any in the Locals page.

But I've still got the problem, even after restarting VBA.

I didn't specifically say, but it's changed ALL my Ranges!

I sure hope someone can help, as I'm dead in the water
like this.

ciao,
Peter




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Peter

All you need to do is create a variable with the capitalization you want.
Then delete it.

Dim Range

the delete it. Now

Dim x As Range

will be capitalized how you expect.

When you create a variable (or property, in your case) that is a keyword,
VBA remembers the capitalization even after you delete the
variable/property. This just tricks into doing it right.


--
**** Kusleika
Excel MVP
Daily Dose of Excel
www.*****-blog.com



peter wrote:
> UPDATE
>
> What prob. caused it was that I defined the name of a Property
> method to be 'range'.
>
> I've removed that and changed every other 'range' and there's
> no sign of any in the Locals page.
>
> But I've still got the problem, even after restarting VBA.
>
> I didn't specifically say, but it's changed ALL my Ranges!
>
> I sure hope someone can help, as I'm dead in the water
> like this.
>
> ciao,
> Peter
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

That's great, thanks ****.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!