I have created a template in my verison of excel 2000, when testing it in
other versions of excel I have installed on a virtual machine I am getting
the error message
"cannot find project or library ", upon debugging the code I can see that it
is falling down on the lines of code that use the following functions
right()
chr()
as far as I can remember i have not got these functions from any add-ins or
anything, they just came with my version of Excel.
they are pretty standard functions

Can anyone shed any light before I throw myself off the roof