dl,
The problem is probably not related to Excel directly, but a missing
reference to another component.
Check the References for one marked "Missing".

VB/VBA will through an error at any line if this is the case.

NickHK

"dl" wrote in message
...
I have an excel workbook with macros. This works fine on one machine but
not
on another as an object library is not present for the basic function
LCASE.
Can someone direct me on why as both machines use Excel 9. Any help would
be
useful.