Error 2029 using Find XL 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using the find code in VB to find text in Excel The range returned is
error 2029..

Where Found is defined as a range..
The code is:

Set Found = look.Find(What:=FindTag(X - 1), LookIn:=xlFormulas,
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=True)

Found gets returned Error 2029.. Which I cannot figure out.. It should
return nothing if it doesn't find it, and the cell of the first occurance if
it does..
ANY HELP WOULD BE GREATLY APPRECIATED!!!
 
Back
Top