| xlCellTypeAllFormatConditions | Any type of Cells (-4172) |
| xlCellTypeAllValidation | Cells with Validation Criteria (-4174) |
| xlCellTypeBlanks | Blank Cells (4) |
| xlCellTypeComments | Cells with Comments (-4144) |
| xlCellTypeConstants | Cells with Constants (Non-Formula & Non-Blank) (2) |
| xlCellTypeFormulas | Cells with Formulas (beginning with a =) (-4123) |
| xlCellTypeLastCell | Get Last Cell in the UsedRange (11) |
| xlCellTypeSameFormatConditions | Cells with Common Format Conditions (-4173) |
| xlCellTypeSameValidation | Cells with Common Validation Criteria (-4175) |
| xlCellTypeVisible | All Visible Cells (12) |