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

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

Rob,

I checked my references, and none of them say broken or missing. Are there
any other references that you feel I need to get the chr function?

Bill


"Rob van Gelder" wrote in message
...
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

In my experience, VBA functions which suddenly appear invalid are caused by
References being unavailable on the target PC.
Try unchecking each reference. Run again. Check the reference again. Run
again.

Chr is a function of the "Visual Basic for Applications" Reference.

Can you describe how this problem started? Are you running it on a PC
difference from your development PC?


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


"Bill Murphy" wrote in message
...
Rob,

I checked my references, and none of them say broken or missing. Are
there
any other references that you feel I need to get the chr function?

Bill


"Rob van Gelder" wrote in message
...
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