"Dave Peterson" wrote in message
...
Open the workbook with the problem
Go into the VBE
Select that workbook's project
Click on Tools|References, look for a MISSING reference.

Delete it or replace it with one that you need.

Missing references can cause errors that have no relationship to the line
that's
marked as error.

But a sure sign that a reference is missing is a compile error on a member
of the Strings library, such as Trim, Format, Left, etc. Strings is the
canary in the VBA coal mine.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______