Search notes:

Excel Object Model: the xlCellType enumeration

The values of the xlCellType enumeration are used in the range.specialCells method to find cells that have a specific content.
Member Value ~Description` Comment
xlCellTypeAllFormatConditions -4172 Cells of any format.
xlCellTypeAllValidation -4174 Cells having validation criteria.
xlCellTypeBlanks 4 Empty cells. Compare with the isBlank() worksheet function.
xlCellTypeComments -4144 Cells containing notes.
xlCellTypeConstants 2 Cells containing constants.
xlCellTypeFormulas -4123 Cells containing formulas.
xlCellTypeLastCell 11 The last cell in the used range. The worksheet.usedRange property.
xlCellTypeSameFormatConditions -4173 Cells having the same format. see also conditional formatting.
xlCellTypeSameValidation -4175 Cells having the same validation criteria.
xlCellTypeVisible 12 All visible cells.

Index