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. | |