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

Hi Dr. Schwartz,

In the VBE, with the problematic workbook's project selected, go to:

Tools | References

and look for any entries marked 'Missing'.

Uncheck these if they are not needed or use the browse button to locate the
reference.


---
Regards,
Norman



"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

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