More than likely there is a broken reference.
Commonly occurs on a different PC to the developer due to some component not
installed.

From VBA | Tools | References, check for a reference which says Broken.

Suspect it is ActiveX Data Objects 2.8


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bill Murphy" wrote in message
...
I have all the normal references set like:

VBA
Excel 10.0 Object library
Windows common controls 6.0
VBA for applications extensibility 5.3
ActiveX data objects 2.8

When I compile my VBA code containing the chr function, which I thought
was
very common, I get a "Can't find project or library" error message with
chr
highlighted. Is there another reference I should set in my workbook to
prevent this?

Bill