Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Edward Ulle" wrote in message ... I'm using Find and not FindNext so I'm assuming every call to Find resets to the top of the column and search down until found or not. Not necesarilly. Where to start from and which directionto look are parameters to find. Like this: Find(What:="abcdef", After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) As Dave said, set everything yourself. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Method problem in Excel VBA.... | Excel Worksheet Functions | |||
Problem with the FIND method looking for dates. | Excel Programming | |||
Using variables to make a date and using find method to find that. | Excel Programming | |||
Problem with find method | Excel Programming | |||
range.find method called into a VBA function (problem) | Excel Programming |