Excel.SpecialCellType enum
Remarks
Fields
| blanks = "Blanks" | Cells with no content. |
| conditionalFormats = "ConditionalFormats" | All cells with conditional formats. |
| constants = "Constants" | Cells containing constants. |
| dataValidations = "DataValidations" | Cells with validation criteria. |
| dirtyFormulas = "DirtyFormulas" | Cells contain formulas which don't have up-to-date results. |
| formulas = "Formulas" | Cells containing formulas. |
| sameConditionalFormat = "SameConditionalFormat" | Cells with the same conditional format as the first cell in the range. |
| sameDataValidation = "SameDataValidation" | Cells with the same data validation criteria as the first cell in the range. |
| visible = "Visible" | Cells that are visible. |