View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PATS PATS is offline
external usenet poster
 
Posts: 17
Default 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