Find special cells

This section shows how to find special cells with the IRange.SpecialCells() method. Following types are supported to find: - **SpecialCellType.AllFormatConditions**: Cells of any format condition in the specified range. - **SpecialCellType.AllValidation**: Cells having validation criteria in the specified range. - **SpecialCellType.Blanks**: Empty cells in the specified range. - **SpecialCellType.Comments**: Cells containing notes in the specified range. - **SpecialCellType.Constants**: Cells containing constants. - **SpecialCellType.Formulas**: Cells containing formulas. - **SpecialCellType.LastCell**: The last visible cell in the used range of the worksheet of the specified range. - **SpecialCellType.SameFormatConditions**: Cells having the same format as the top-left cell of the specified range. - **SpecialCellType.SameValidation**: Cells having the same validation criteria as the top-left cell of the specified range. - **SpecialCellType.Visible**: All visible cells in the specified range. - **SpecialCellType.MergedCells**: Merged cells that intersects with the specified range. - **SpecialCellType.Tags**: Cells containing tags in the specified range. When finding for cells of type **SpecialCellType.Constants** or **SpecialCellType.Formulas**, can specify the supported value types: - **SpecialCellsValue.TextValues**: Cells with text. - **SpecialCellsValue.Numbers**: Cells with numeric values. - **SpecialCellsValue.Logical**: Cells with logical values. - **SpecialCellsValue.Errors**: Cells with errors.