Excel.SpecialCellType enum

Remarks

[ API set: ExcelApi 1.9 ]

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.

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.