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!