On any of the affected machines (with the spreadsheet open) in the VBE check
Tools - References and look for any references that are listed as
"Missing:". You may be able to just uncheck the reference and it will work
just fine. If not reply back with the name of the reference that is missing.
--
HTH...

Jim Thomlinson


"Peter" wrote:

To all great minds out the
A number of people have just started having issues with some macros
that I wrote a while ago which have been working fine up until now.
There is a compile error that keeps coming up. Variable that were not
declared are hightlighted which I have fixed by declaring the
variable, however the big problem is when functions like Mid are
highlighted as the problem. Does anyone have any idea on what to do to
sort this problem out?

Thanks,

Peter