'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, _ ByVal rowEnd As Integer, _ ByVal columnEnd 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 rowEnd As Integer Dim columnEnd As Integer Dim foundRowIndex As Integer Dim foundColumnIndex As Integer Dim value As SearchFoundFlags value = instance.Search(searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, rowEnd, columnEnd, foundRowIndex, foundColumnIndex)
public SearchFoundFlags Search( string searchString, SearchFlags searchFlags, SearchOrder searchOrder, SearchFoundFlags searchTarget, SheetArea sheetArea, int rowStart, int columnStart, int rowEnd, int columnEnd, out int foundRowIndex, out int foundColumnIndex )
Parameters
- searchString
- The string for which to search.
- searchFlags
- The SearchFlags enumeration that specifies the options of the search.
- searchOrder
- The SearchOrder enumeration that specifies whether the search goes by column then row coordinates or row then 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.
- rowEnd
- The row index at which to end.
- columnEnd
- The column index at which to end.
- foundRowIndex
- The row index at which a match is found.
- foundColumnIndex
- The column index at which a match is found.
Return Value
A SearchFoundFlags enumeration that specifies what is matched.