Error 2029 using Find XL 97

J

jonnyexcelneill

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Need help with correct syntax please 2
Using While Wend with Cells.Find 1
Getting Excel Find to Default to Searching Workbook not Sheet 3
Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
Set Column choice to a variable from a Drop Down 4
Range With Variables 1
On error goto specified Line 6

Top