You can search for data in any of the cells in the workbook by specifying the sheet and the string of data for which to search. You can also pop-up a search dialog and allow the end user to search for data. The methods and properties that relate to searching and search dialogs are part of the Spread component.
The tasks for searching include:
- Allowing the User to Perform a Standard Search
- Allowing the User to Perform an Advanced Search
- Searching for Data with Code
There are limitations to the search. Row and column headers are not searched with the search dialogs; only cells are searched.Use the SearchHeaders method to search the headers. None of the information in the sheet, column, or row object is included in the search. Not all tags are included when you search and "include tags"; only cell tags are included.
Return to the overall list of tasks in Customizing Sheet Interaction.