The problem probably isn't the difference between 2003 and 2007. The
find function uses the same function as the worksheet find (2003 menu
Edit - find). the find doesn't have a default value for some of the
parameters. the find uses whatever was last set in the worksheet. So
you probably just have to add all the parameters in the find function.
OPen up the worksheet find and look at the option. You will see that it
is set incrorrectly.
expression.Find(What, After, LookIn, LookAt, SearchOrder,
SearchDirection, MatchCase, MatchByte, SearchFormat)
Usually as a mimimum you need to specfiy the
LookIn:=xlvalues, lookat:=xlwhole, MatchCase:=False
Lookat can also be xlpart
The most common failure like this is the Part vs Whole
--
joel
------------------------------------------------------------------------
joel's Profile:
http://www.thecodecage.com/forumz/member.php?userid=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=149293