Heres Something Strange

[ScottInTexas]

So I'm working along and all of a sudden the key word Range is now replaced with range (lower case). When I type the word the first letter is capitalized, but when I complete the line and move on the capital R goes to lower case. I don't know where I could have changed a reserved word.

I'm certain my machine is possessed.

Any idea where I made the change? I have not defined any variable as Range or range.

 

[Norie]

Did you call anything 'range'?

And I mean anything - variable, module, sub, function...

Also do you have any add-ins installed?

 

[sheetspread]

Look here:

http://www.mrexcel.com/forum/excel-questions/43353-word-range-does-not-stay-capitalized.html

The only way I can replicate that behaviour is if I have at some time dimensioned a variable named "range". Then, even if I delete the Dim statement, Range is still uncapitalized.

The solution is to temporarily insert:

Dim Range

so that the occurrences are capitalized, and then delete it.

 

[jtakw]

Hi,

Your computer is probably not possessed, unless: The Top 11 Signs Your Computer is Possessed

 

[ScottInTexas]

Excellent, Sheetspread! I have exorcised the demon!
Nori - I had a sheet named "Ranges." Not Range. I renamed it to NamedRanges. Now that I am done with it I have deleted it. I did the Dim Range and everything went back to normal. I may have typed Dim Range somewhere along the way and then said "Hey, idiot, you can't use Range there!" Then deleted it and corrected the bone head error. I don't remember doing that, but it is possible.

Anyway, all is back to bliss.

Thank you so much for your replies.