Searches the text in the cells in the specified sheet for the specified string with the specified criteria.
Syntax
'Declaration
Public Overloads Sub Search( _
ByVal As Integer, _
ByVal As String, _
ByVal As SearchFlags, _
ByVal As SearchOrder, _
ByRef As Integer, _
ByRef foundColumnIndex As Integer _
)
'Usage
Dim instance As Workbook
Dim sheetIndex As Integer
Dim searchString As String
Dim searchFlags As SearchFlags
Dim searchOrder As SearchOrder
Dim foundRowIndex As Integer
Dim foundColumnIndex As Integer
instance.Search(sheetIndex, searchString, searchFlags, searchOrder, foundRowIndex, foundColumnIndex)
Parameters
- sheetIndex
- The index of the sheet on which to search.
- searchString
- The string for which to search.
- searchFlags
- The search options.
- searchOrder
- Whether to conduct the search by column, row coordinates or row, column coordinates.
- foundRowIndex
- The index of the row at which a match is found.
- foundColumnIndex
- The index of the column at which a match is found.
See Also