Search(Int32,String,SearchFlags,Int32,Int32) Method
In This Topic
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, _
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 foundRowIndex As Integer
Dim foundColumnIndex As Integer
instance.Search(sheetIndex, searchString, searchFlags, foundRowIndex, foundColumnIndex)
public void Search(
int ,
string ,
SearchFlags ,
out int ,
out int foundColumnIndex
)
Parameters
- sheetIndex
- The index of the sheet on which to search.
- searchString
- The string for which to search.
- searchFlags
- The search options.
- 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