| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem sorting by date after 2029 on Excel 2003 | Excel Discussion (Misc queries) | |||
| Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
| how to find an error | Excel Discussion (Misc queries) | |||
| help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
| Error if can't find text | Excel Programming | |||
Linear Mode
