Error 2029 using Find XL 97
 

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!!!

Error 2029 using Find XL 97
 

..."= look.Find"
Is "look" a valid range?
--
Regards
Rob
"jonnyexcelneill" wrote in
message ...
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!!!