Hi there.

Im trying to use the Left() function to extract the first
5 characters from strings that are in cells on 2 different
worksheets. I understand how to extract the strings, and
i understand how Left() works. But for the life of me i
cant find out why im getting a compiler error when i try
to use Left().
When i run my function i get the error "Compile error:
Can't find project or library". and it highlights the Left
function call. can anyone tell my whey this is happening?
iv search the forums, i search the support site, even
checked programming refrence books on VBA for Excel, but
none talk about a error like this.

Here is what my code looks like if you need to see it.
....
szTemp1 = Worksheets(1).Cells(nx, 22)
szTemp2 = Worksheets(2).Cells(nRange2,
nRange3)
szTemp1 = Left(szTemp1, 5)
szTemp2 = Left(szTemp2, 5)
....