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