.Find Method for Excel 2002

[jwells]

I am having troubles figuring out a problem with Excel 2002. I have made code on Excel 2003 that works fine but when it is ran on Excel 2002 an error occurs (Can't Find Project or Library). Below is the code that is having trouble with Excel 2002. If you have any suggestions why the code doesn't work, or what code will work I would very much appreciate it. Thanks,


Code

Set Find_Criteria = Worksheets("Sheet1").Range("B:B").Find(What:="*X*Axis*1*", Lookat:=xlPart)

[Jim Thomlinson]

When you have a missing reference then weird things start to happen . There
is nothing wrong with that line of code (in all likelyhood). What you need to
do is to go the the VB Editor and click on Tools -> References and look for a
checked item that starts with "Missing". chances are you just need to find an
older version of the same reference. If you are missing Whatever 2.8 then
uncheck it and look for a Whatever 2.7.
--
HTH...

Jim Thomlinson


"jwells" wrote:

>
> I am having troubles figuring out a problem with Excel 2002. I have
> made code on Excel 2003 that works fine but when it is ran on Excel
> 2002 an error occurs (Can't Find Project or Library). Below is the
> code that is having trouble with Excel 2002. If you have any
> suggestions why the code doesn't work, or what code will work I would
> very much appreciate it. Thanks,
>
>
> Code
>
> Set Find_Criteria =
> Worksheets("Sheet1").Range("B:B").Find(What:="*X*Axis*1*",
> Lookat:=xlPart)
>
>
> --
> jwells
> ------------------------------------------------------------------------
> jwells's Profile: http://www.excelforum.com/member.php...o&userid=30413
> View this thread: http://www.excelforum.com/showthread...hreadid=500787
>
>