'Declaration
 
Public Overloads Function Search( _
   ByVal searchString As String, _
   ByVal searchFlags As SearchFlags, _
   ByVal searchOrder As SearchOrder, _
   ByVal searchTarget As SearchFoundFlags, _
   ByVal sheetArea As SheetArea, _
   ByVal rowStart As Integer, _
   ByVal columnStart As Integer, _
   ByRef foundRowIndex As Integer, _
   ByRef foundColumnIndex As Integer _
) As SearchFoundFlags

'Usage
 
Dim instance As Worksheet
Dim searchString As String
Dim searchFlags As SearchFlags
Dim searchOrder As SearchOrder
Dim searchTarget As SearchFoundFlags
Dim sheetArea As SheetArea
Dim rowStart As Integer
Dim columnStart As Integer
Dim foundRowIndex As Integer
Dim foundColumnIndex As Integer
Dim value As SearchFoundFlags
 
value = instance.Search(searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, foundRowIndex, foundColumnIndex)

public SearchFoundFlags Search( 
   string searchString,
   SearchFlags searchFlags,
   SearchOrder searchOrder,
   SearchFoundFlags searchTarget,
   SheetArea sheetArea,
   int rowStart,
   int columnStart,
   out int foundRowIndex,
   out int foundColumnIndex
)

Parameters

searchString

The string for which to search.

searchFlags

The SearchFlags enumeration that specifies the search options.

searchOrder

The SearchOrder enumeration that specifies whether the search uses column, row coordinates or row, column coordinates.

searchTarget

The SearchFoundFlags enumeration that indicates whether the search includes the content in the cell notes, tags, or text.

sheetArea

The sheet area to search.

rowStart

The row index at which to start.

columnStart

The column index at which to start.

foundRowIndex

The row index at which the match is found.

foundColumnIndex

The column index at which the match is found.

Return Value

Reference

Worksheet Class
Worksheet Members
Overload List