| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
type mismatch on find function
I am getting a type mismatch on this Dim intResult As Integer intResult = Range("a:a").Find(What:="abc", After:="A44", LookIn:=xlValues,_ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,_ MatchCase:=False, SearchFormat:=False).Row I have also tried intResult = Cells.Find(What:="abc", After:="A44", ...).Row intResult = Selection.Find(What:="abc", After:="A44", ...).Row |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type mismatch error in Find method | Excel Programming | |||
| FIND type mismatch error, but don't see it | Excel Worksheet Functions | |||
| Type mismatch error on Find | Excel Programming | |||
| Type Mismatch - Match function | Excel Programming | |||
| Type mismatch in look up function | Excel Programming | |||
Threaded Mode
