Find [WksRange]

The Find method finds and selects cell entries with the specified text.

object.Find( TargetStr, After, Scope, Method, MatchCase, DelSelFirst, FindAll, OrderByRows )

Parameter	Type	Description
TargetStr	String	required; target text
After	IWksRange	required;
Scope	wksFindScope	optional; specifies search scope
Method	wksFindMethod	optional; specifies search method
MatchCase	Boolean	optional; "true" to match case
DelSelFirst	Boolean	optional; "true"
FindAll	Boolean	optional; "true" to find all matching cells
OrderByRows	Boolean	optional; "true" searches by row order

'Find

'Find and select all cell entries with "New" in the cell

Wks.UsedRange.Find(TargetStr:="New", After:=Nothing, Method:=wksFindPhrase, FindAll:=True)