'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, _ ByRef foundString As String _ ) 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 foundString As String Dim value As SearchFoundFlags value = instance.Search(searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, rowEnd, columnEnd, foundRowIndex, foundColumnIndex, foundString)
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, out string foundString )
Parameters
- searchString
- The string for which to search.
- searchFlags
- The SearchFlags enumeration that specifies the options of the search.
- searchOrder
- The SearchFlags enumeration that specifies whether the search goes by column, row coordinates or row, column coordinates.
- searchTarget
- The SearchFoundFlags enumeration that indicates whether the search includes the content in the cell notes, tag, or text.
- sheetArea
- The area of the sheet to search.
- rowStart
- The starting index of the row at which to start.
- columnStart
- The starting index of the column at which to start.
- rowEnd
- The ending index of the row at which to end.
- columnEnd
- The ending index of the column at which to end.
- foundRowIndex
- The row index at which a match is found.
- foundColumnIndex
- The column index at which a match is found.
- foundString
- The found string.
Return Value
A SearchFoundFlags enumeration that specifies what is matched.