ExcelWorksheetFind(String) Method |
Finds the cells of the worksheet that display the specified text, in any part of the cell and without
regard to case. The text of a formula cell is its calculated result; call
UpdateFormulaResult first to calculate the formulas added in code.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic ExcelRange[] Find(
string text
)
Public Function Find (
text As String
) As ExcelRange()
Parameters
- text String
- The text to find.
Return Value
ExcelRangeThe cells that display the text, row by row. The array is empty when no cell displays the text.
See Also