Ya, there was a missing refrence, and un-checking it fixed
my problem. Im now worried about distribution of my sheet
to my users. Are they going to possibly get the same
error i did? Is there a way to prevent it from happening?

Thanks for the replies

-----Original Message-----
Run the code till you get the error.

Make sure the workbook with the problem is the active
**project** (not just
the active workbook).

Then go to tools references in the VBE.

You should see a reference shown as MISSING.

If you don't fix this, it will probably occur in some
other line of code.

--
Regards,
Tom Ogilvy

"bryce" wrote in message
...
Cant find the missing refrence that i would need. Left
()
is also listed in the Object Browser (so it should
technically be there, right?)

But anyways...found a work around for it. Since i only
want the first 5 character for it i set my szTemps's to
*
5. Then copied the strings into there. Being that the
strings are set to a specific length it truncates the
rest
of it. Im just waiting for me to need the right side
of a
string then will have funn figuring that one out.

thanks for the response
-----Original Message-----
Hi,

It is possible from missing library. Goto VB Editor,
click
Tools in menu, check Referencs and it will list the
missing library in your file. Unselect the missing
library
and re-run your code.

Best Regards

Bill


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

.



.