It's ok to leave After:=Range("A1"). This just means that the search will
begin with A2 and A1 will be the last cell to be searched. If you omit the
After:= argument the Find method will search the first cell in the range to
be searched, in this case it would be A1. My point is, either way if the
text Katie is searching for will be found if it is in the worksheet. Just
wanted to let you know.
--
Cheers,
Ryan


"joel" wrote:


Leave out the Begin prtion of both the find methods. Putting A1 at the
Begin item will skip A1 and look at cell A1 as the last cell in the
sheet rather than the first cell. If your seatch data is in cell a1
then you may not find what you are expecting.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=183105

Microsoft Office Help

.