After the error, reset then go to Tools=References (in the VBE) and remove
or fix references shown as MISSING

--
Regards,
Tom Ogilvy

"Sohpie" wrote in message
...
Hello Everyone

I've written some code in Excel 2000. Now I've moved to a
new office that uses 2003. When I run the code I get
errors where I use Left, Date and Mid. I can't believe
the MSoft would remove these options. But I can't work
out what's going on.

Can anyone help me?

TIA

Sxx