make sure that you have properly DIM'd the two variables:
DIM szTemp1 As String
DIM szTemp2 As String

Now sometimes this error is misleading - under
Tools/References check to see if there are any "missing"
references...sometimes code is compiled on one machine
then run on another which may not have a relevent dll or
ocx installed. This often causes an error to highlight a
command which is in fact nothing to do with the cause of
the error.

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
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)
....
.