In VB Editor
Check Tools-References
It might be pointing to the Excel 2007 library (Excel12)
Change it to Excel11

"RidgeView" wrote:

I have several worksheets developed in Excel 2007 and have ported them to
computers with Excel 2003. In some cases the following statement works and
in others it does not. An example of the format statement is as follows:
SMth = Format(SecMth, "mmmm")
The macro will not compile because it gets hung up on the "Format" statement
stating that it cannot compile because either the Object or Library is not
found.
Like I stated, this statement does work in other worksheets.
HOW CAN I GET THIS TO WORK?