'Declaration Public Overloads Function Search( _ ByVal sheetIndex As System.Integer, _ ByVal searchString As System.String, _ ByVal searchFlags As SearchFlags, _ ByVal searchOrder As SearchOrder, _ ByVal searchTarget As SearchFoundFlags, _ ByVal sheetArea As SheetArea, _ ByVal rowStart As System.Integer, _ ByVal columnStart As System.Integer, _ ByRef foundRowIndex As System.Integer, _ ByRef foundColumnIndex As System.Integer _ ) As SearchFoundFlags
'Usage Dim instance As Workbook Dim sheetIndex As System.Integer Dim searchString As System.String Dim searchFlags As SearchFlags Dim searchOrder As SearchOrder Dim searchTarget As SearchFoundFlags Dim sheetArea As SheetArea Dim rowStart As System.Integer Dim columnStart As System.Integer Dim foundRowIndex As System.Integer Dim foundColumnIndex As System.Integer Dim value As SearchFoundFlags value = instance.Search(sheetIndex, searchString, searchFlags, searchOrder, searchTarget, sheetArea, rowStart, columnStart, foundRowIndex, foundColumnIndex)
public SearchFoundFlags Search( System.int sheetIndex, System.string searchString, SearchFlags searchFlags, SearchOrder searchOrder, SearchFoundFlags searchTarget, SheetArea sheetArea, System.int rowStart, System.int columnStart, out System.int foundRowIndex, out System.int foundColumnIndex )
Parameters
- sheetIndex
- The index of the sheet on which to search.
- 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, tags, or text.
- sheetArea
- The area of the sheet for the search.
- rowStart
- The index of the row at which to start.
- columnStart
- The index of the column at which to start.
- foundRowIndex
- The index of the row at which a match is found.
- foundColumnIndex
- The index of the column at which a match is found.
Return Value
The found flags.