Open the workbook with the problem (on the problem PC)
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.

Goodenuff wrote:

Hi guys, I suddenly have a wierd problem. Some VBA code (6.5) that works on
my computer fails when the macro runs on another machine???
There is a simple built in function I'm using (Format) that doesn't want to
run.
"FollowUpCalendar.Calendar = Format(Date, "dd mmm yy")"
I've looked under "References - VBAProject and all normal boxes are ticked???

Can anyone please point me in the right direction?

Regards,

Ian

--

Dave Peterson