It is usually cause by a missing reference in the the VBE. (one or more
references will be shown as MISSING)

It is corrected by removing the reference or finding it.

Don't know if that is the case here or not.

--
Regards,
Tom Ogilvy

John Wilson wrote in message
...
As long as it's slow tonight, I have a general question.

I have a workbook that worked fine for a long time.
I do sometimes open it in Excel 2000, 2002, and 2003.
One day, for whatever reason, any Left or Right functions
that I used in my VBA code suddenly started giving me errors??

I've since gone back and changed all the functions to
VBA.Left and VBA.Right and everything works fine.

Does anyone have an explanation as to why this might
happen??

Thanks,
John