This documentation is archived and is not being maintained.

XlCellType Enumeration 

Specifies the type of cells.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlCellType1 As XlCellType = XlCellType.xlCellTypeAllFormatConditions

public enum XlCellType
public enum XlCellType
public enum XlCellType

Member nameDescription
xlCellTypeAllFormatConditionsCells of any format
xlCellTypeAllValidationCells having validation criteria
xlCellTypeBlanksEmpty cells
xlCellTypeCommentsCells containing notes
xlCellTypeConstantsCells containing constants
xlCellTypeFormulasCells containing formulas
xlCellTypeLastCellThe last cell in the used range
xlCellTypeSameFormatConditionsCells having the same format
xlCellTypeSameValidationCells having the same validation criteria
xlCellTypeVisibleAll visible cells

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms