| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop a find after the last occrance of the search value.
Is there any way to cause this routine to stop when it finds the last
occurance of NoXXX and not start over at the top of the worksheet? Sub NextRow() ' ' Macro4 Macro ' ' Cells.Find(What:="NoXXX", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Columns for a word and stop | Excel Discussion (Misc queries) | |||
| Stop Search ---- Ron de Bruin RDB_Filter_Data | Excel Programming | |||
| VB Code to search,copy,paste and stop at blank row! | Excel Programming | |||
| How to stop search / replace prosess in large excel worksheets | Excel Programming | |||
| search a string withing a string : find / search hangs | Excel Programming | |||
Threaded Mode
