This is generally caused by a missing reference in your project rather than
the fact that the functions are available (both Excel 2000 and Excel 2002
use VBA 6 - so they do work in both).

In Excel 2000, go to Tools=References in the VBE and make sure you project
is selected in the project window (one of the elements/components are
highlighted). Then go to Tools=References and you should see one or more
entries shown as MISSING.

You need to unselect these if your project does not use them, or install
them on that machine if it does.

Generally, use as few references as possible and only those you need.

--
Regards,
Tom Ogilvy


"Shawn Shuler" wrote in message
...
Why are there functions and methods lited in the VBA help file for Excel
2000 that seemingly will not work on Excel 2000? A few examples:

Str
LTrim
RTrim
Trim
Chr

The list goes on and on but these are a few of the ones that are
irritating
me right now. Or am I missing a seeting that allows them to work fine on
my
Excel 2002 but prevents them from running on Excel 2000? Every time it
encounters one of these functions it says, "Can't find project or
library."
The worst part is when I run across a function described in an old book
for
Excel 97 VBA that will NOT work on Excel 2000 but does in 2002. What's
the
deal?

I'm just beginning to learn here so please help a novice out.