Have you got any missing references in ToolsReferences? If so uncheck them.

--
HTH

Bob Phillips

"Dr.Schwartz" wrote in message
...
Can anybody tell me why I sometimes need to put VBA. in front of eg. Right
or
Chr?

On different Excel installations/computers that supposively should be
identical some give me an error when I run the code without VBA. in front.

Does anybody know what setting causes this phenomenon?

Thanks
The Doctor