why VBA. ?
 

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

why VBA. ?
 

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

why VBA. ?
 

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