View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shawn Shuler Shawn Shuler is offline
external usenet poster
 
Posts: 7
Default Excel 2000 VBA Help File

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.