Greg,
Check the references and their order for the workbook. Any marked as missing
?
After typing "Excel." (with the full stop), what do you see ?

NickHK

"Greg Wilson" wrote in message
...
I tried that in my experiments also but forgot to mention it.
"Excel.Range"
becomes "Excel.range" and if you type "Excel.range" it is accepted
unchanged.

Regards,
Greg

"NickHK" wrote:

Peter,
What happens if you type:
Dim r As Excel.range

NickHK

"peter" wrote in message
...
In several Modules or Class Modules if I add a new line
"Dim r As Range",
the 'R' changes to 'r' when I press Enter.

Auto Syntax Check is not enabled.

I can't think of any changes I've made to the IDE
that could cause this.

Thanks for your help,
Peter.




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