Overload | Description |
---|---|
SearchWithDialogAdvanced(String) | Searches the text in the cells of the sheets for the search string with the default criteria using a provided advanced search dialog. |
SearchWithDialogAdvanced(Int32,Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32) | Searches the text in the cells of the specified sheet range for the specified string with the specified criteria using a provided advanced search dialog. |
These search methods have these qualifications:
- Searches all the cells that contain data that can be represented as a string by the Text property of that cell, and that includes hidden and locked cells
- Only checks the formatted string, that is the Text in the cell, not the Value
- Only searches the cells in the data area, not the headers
- Only searches the specified cells in one sheet
- Cell notes and cell tags are not searched
For a hierarchy of sheets, these methods only search cells in a parent sheet. To search child sheets, you would need to perform a separate search of each child sheet.
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8