Hi,

I am running a macro that I wrote a year ago. I didn't make any changes. But
it dosen't work this time!

The problem is, for all the variables I haven't defined explicitly, it gave
me an error message "Can't find project or library". What's more, when I was
using function
"Right("Excel", 4)", it gave me the same error message! And Now I have to
write
"Strings.Right("Excel",4)" to clear the error.

Could anybody give me suggestions to solve this problem? Thanks a lot!

You have a missing reference.
In the VBE do Tools, References and you will see what it is.

RBS

"salut" wrote in message
...
Hi,

I am running a macro that I wrote a year ago. I didn't make any changes.
But
it dosen't work this time!

The problem is, for all the variables I haven't defined explicitly, it
gave
me an error message "Can't find project or library". What's more, when I
was
using function
"Right("Excel", 4)", it gave me the same error message! And Now I have to
write
"Strings.Right("Excel",4)" to clear the error.

Could anybody give me suggestions to solve this problem? Thanks a lot!