Complete List

AggregationFunction(1.8) Specifies the aggregation function for the data pivot field.
ArrowheadLength(1.9) Specifies the length of the arrowhead at the end of a line (xlArrowHeadLength)
ArrowheadStyle(1.9) Specifies the type of arrowhead to apply to the line end.
ArrowheadWidth(1.9) Specifies the width of the arrowhead at the end of a line.
AutoFillType(1.9) Specifies how the target range is to be filled, based on the contents of the source range (xlAutoFillType)
BindingType(1.1)
BorderIndex(1.1) Specifies the border to be retrieved (xlBordersIndex)
BorderLineStyle(1.1) Specifies the line style for the border (xlLineStyle)
BorderWeight(1.1) Specifies the weight of the border around a range (xlBorderWeight)
BuiltInPivotTableStyle(beta)
BuiltInSlicerStyle(beta) Specifies the built-in slicer styles.
BuiltInStyle(1.7) Specifies the built-in cell styles.
BuiltInTableStyle(beta) Specifies a built-in table style.
CalculationMode(1.7) Specifies the calculation mode (xlCalculation)
CalculationState(1.9) Specifies the calculation state across the entire Excel application (or workbook ?).
CalculationType(1.1) Specifies the type of calculation to perform.
ChartAxisCategoryType(1.7) Specifies the type of the category axis (xlCategoryType)
ChartAxisDisplayUnit(1.7) Specifies the display unit label for an axis (xlDisplayUnit)
ChartAxisGroup(1.7) Specifies the type of axis group (xlAxisGroup)
ChartAxisPosition(1.7) Specifies the point on the specified axis where the other axis crosses (xlAxisCrosses)
ChartAxisScaleType(1.7) Specifies the scale type of the value axis (xlScaleType)
ChartAxisTickLabelPosition(1.7) Specifies the position of tick-mark labels on the specified axis (xlTickLabelPosition)
ChartAxisTickMark(1.7) Specifies the position of major and minor tick marks for an axis (xlTickMark)
ChartAxisTimeUnit(1.7) Specifies unit of time for chart axis and data series (xlTimeUnit)
ChartAxisType(1.7) Specifies the axis type (xlAxisType)
ChartBinType(1.9) Specifies the bin's type of a histogram chart or pareto chart series (xlBinsType)
ChartBoxQuartileCalculation(1.9) Specifies the quartile calculation type for a chart series layout.
ChartColorScheme(1.8)
ChartDataLabelPosition(1.1) Specifies where the data label is positioned (xlDataLabelPosition)
ChartDisplayBlankAs(1.8) Specifies how blank cells are plotted on a chart (xlDisplayBlankAs)
ChartErrorBarsInclude(1.9) Specifies which error bar parts to include (xlErrorBarInclude)
ChartErrorBarsType(1.9) Specifies the range marked by error bars (xlErrorBarType)
ChartGradientStyle(1.9) Specifies the gradient style of a chart series.
ChartGradientStyleType(1.9) Specifies the gradient style type of a chart series.
ChartLegendPosition(1.1) Specifies the position of the legend on a chart (xlLegendPosition)
ChartLineStyle(1.7) Specifies the line style for the border (xlLineStyle)
ChartMapAreaLevel(1.9) Specifies the mapping level of a chart series.
ChartMapLabelStrategy(1.9) Specifies the region level of a chart series.
ChartMapProjectionType(1.9) Specifies the region projection type of a chart series.
ChartMarkerStyle(1.7) Specifies the marker style for a point or series in a line chart, scatter chart or radar chart (xlMarkerStyle)
ChartParentLabelStrategy(1.9) Specifies the parent label strategy of a chart series layout.
ChartPlotAreaPosition(1.8) Specifies the position of the plot area.
ChartPlotBy(1.8) Specifies whether the values corresponding to a particular data series are in rows or columns (xlRowCol)
ChartSeriesBy(1.1) Specifies whether the series are by rows or by columns.
ChartSeriesDimension(beta) Specifies the dimensions when getting values from chart series.
ChartSplitType(1.8)
ChartTextHorizontalAlignment(1.7) Specifies the horizontal alignment for the object (xlHAlign)
ChartTextVerticalAlignment(1.7) Specifies the vertical alignment for the object (xlVAlign)
ChartTickLabelAlignment(1.8) Specifies the alignment for chart tick labels.
ChartTitlePosition(1.7) Specifies the position of the chart title.
ChartTrendlineType(1.7) Specifies how the trendline that smoothes out fluctuations in the data is calculated (xlTrendlineType)
ChartType(1.1) Specifies the chart type (xlChartType)
ChartUnderlineStyle(1.1) Specifies the type of underline applied to a font (xlUnderlineStyle)
ClearApplyTo(beta)
CloseBehavior(1.9) Specifies the close behavior for the workbook.close event.
CommentChangeType(1.12) Specifies how the comments in the event were changed.
ConditionalCellValueOperator(1.6) Specifies the operator of the text conditional format type.
ConditionalDataBarAxisFormat(1.6) Specifies the format options for a data bar axis.
ConditionalDataBarDirection(1.6) Specifies the data bar direction within the cell.
ConditionalFormatColorCriterionType(1.6) Specifies the type of conditional format values.
ConditionalFormatDirection(1.6) Specifies the direction for a selection.
ConditionalFormatIconRuleType(1.6) Specifies the type of rules for icon conditional formatting.
ConditionalFormatPresetCriterion(1.6) Specifies the criteria for the preset criteria conditional format type.
ConditionalFormatRuleType(1.6) Specifies the type of rules for conditional formatting.
ConditionalFormatType(1.6) Specifies the different types of conditional formatting.
ConditionalIconCriterionOperator(1.6) Specifies the operator for each icon criteria.
ConditionalRangeBorderIndex(1.6) Specifies the type of border applied.
ConditionalRangeBorderLineStyle(1.6) Specifies the type of line style applied to the border.
ConditionalRangeFontUnderlineStyle(1.6) Specifies the type of underline applied to the font.
ConditionalTextOperator(1.6) Specifies the operator for the text conditional format type.
ConditionalTopBottomCriterionType(1.6) Specifies the criteria for the above/below average conditional format type.
ConnectorType(1.9) Specifies the type of connector.
ContentType(1.10) Specifies the different content types.
CustomFunctionMetadataFormat(beta)
CustomFunctionType(beta)
DataChangeType(1.7) Specifies the different triggers for a data changed event.
DataValidationAlertStyle(1.8) Specifies the icon used in message boxes displayed during validation (xlDVAlertStyle)
DataValidationOperator(1.8) Specifies the operator to use for data validation.
DataValidationType(1.8) Specifies the type of validation test to be performed in conjunction with values (xlDVType)
DateFilterCondition(1.12) Specifies all accepted conditions by which a date filter can be applied.
DeleteShiftDirection(1.1) Specifies how to shift cells to replace deleted cells (xlDeleteShiftDirection)
DocumentPropertyItem(1.7) Specifies the document property items.
DocumentPropertyType(1.7) Specifies the data type of the document property.
DynamicFilterCriteria(1.2)
ErrorCodes(beta)
EventSource(1.7) Specifies the source of the event.
EventTriggerSource(beta)
EventType(1.7) Specifies the different types of event.
FillPattern(1.9) Specifies the interior pattern of a cell or object (xlPattern)
FilterDatetimeSpecificity(1.2) Specifies the different components of a date and time.
FilterOn(1.2)
FilterOperator(1.2) Specifies the type of opertor to use for the filter.
GeometricShapeType(1.9) Specifies the shape type for a geometric shape object.
GroupOption(1.10)
HeaderFooterState(1.9) Specifies the type of header.
HorizontalAlignment(1.1) Specifies the horizontal alignment for the object (xlHAlign)
IconSet(1.2) Specifies the type of icon set (xlIconSet)
ImageFittingMode(1.2)
InsertShiftDirection(1.1) Specifies the direction in which to shift cells during an insertion (xlInsertShiftDirection)
KeyboardDirection(1.3)
LabelFilterCondition(1.12) Specifies all accepted conditions by which a label filter can be applied.
LinkedDataTypeRefreshMode(beta)
LinkedDataTypeState(1.9) Specifies the state of a linked data type.
NamedItemScope(1.4) Specifies the scope of a named range.
NamedItemType(1.1)
NumberFormatCategory(1.12) Specifies the category of number formats.
PageOrientation(1.7) Specifies the page orientation when the worksheet is printed (xlPageOrientation)
PaperType(1.9) Specifies the size of the paper (xlPaperSize)
PictureFormat(1.9) Specifies the type of picture file format.
PivotAxis(1.9) Specifies the axis from which to get the PivotItems.
PivotFilterTopBottomCriterion(1.9) Specifies the criteria for the top/bottom values filter.
PivotFilterType(1.12) Specifies the type of filter for a PivotField.
PivotLayoutType(1.8)
PivotTableDateGroupBy(beta)
Placement(1.9) Specifies the way that an object is attached to its underlying cells.
PrintComments(1.9) Specifies where to print comments.
PrintErrorType(1.9) Specifies the type of print error displayed (xlPrintErrors)
PrintMarginUnit(1.9)
PrintOrder(1.9)
ProtectionSelectionMode(1.7)
RangeCopyType(1.9)
RangeUnderlineStyle(1.1) Specifies the type of underline applied to a range.
RangeValueType(1.1)
ReadingOrder(1.7) Specifies the reading order.
RibbonTab(1.9) Specifies the different built-in tabs.
RowHiddenChangeType(1.11)
SaveBehavior(1.9) Specifies the save behavior for the workbook.save event.
SearchDirection(1.9) Specifies the search direction when searching a range (xlSearchDirection)
ShapeAutoSize(1.9) Specifies the type of automatic sizing allowed.
ShapeFillType(1.9) Specifies the fill type for a shape.
ShapeFontUnderlineStyle(1.9) Specifies the type of underline applied to a font.
ShapeLineDashStyle(1.9) Specifies the dash style for a line.
ShapeLineStyle(1.9) Specifies the style for a line.
ShapeScaleFrom(1.9) Specifies which part of the shape retains its position when the shape is scaled.
ShapeScaleType(1.9) Specifies whether the shape is scaled relative to its original or current size.
ShapeTextHorizontalAlignment(1.9) Specifies the horizontal alignment for the text frame in a shape.
ShapeTextHorizontalOverflow(1.9) Specifies the horizontal overflow for the text frame in a shape.
ShapeTextOrientation(1.9) Specifies the orientation for the text frame in a shape.
ShapeTextReadingOrder(1.9) Specifies the reading order for the text frame in a shape.
ShapeTextVerticalAlignment(1.9) Specifies the vertical alignment for the text frame in a shape.
ShapeTextVerticalOverflow(1.9) Specifies the vertical overflow for the text frame in a shape.
ShapeType(1.9) Specifies the type of a shape.
ShapeZOrder(1.9) Specifies where in the z-order a shape should be moved relative to other shapes.
SheetVisibility(1.1) Specifies whether the worksheet is visible (xlSheetVisibility)
ShowAsCalculation(1.8) Specifies the ShowAs Calculation function for the Data Pivot Field.
SlicerSortType(1.10) Specifies the slicer sort behavior for Slicer.sortBy API.
SortBy(1.8) Specifies the sort order for the specified field or range (xlSortOrder)
SortDataOption(1.2) Specifies how to sort text (xlSortDataOption)
SortMethod(1.2) Specifies the type of sort (xlSortMethod)
SortOn(1.2) Specifies the parameter on which the data should be sorted (xlSortOn)
SortOrientation(1.2) Specifies the sort orientation (xlSortOrientation)
SpecialCellType(1.9)
SpecialCellValueType(1.9)
SubtotalLocationType(1.8) Specifies where the subtotal will be displayed on the worksheet (xlSubtotalLocationType)
TaskHistoryRecordType(beta)
TopBottomSelectionType(1.12) Specifies the filters to select whether to filter by the top N or bottom N percent, number, or sum of values.
ValueFilterCondition(1.12) Specifies all accepted conditions by which a value filter can be applied.
VerticalAlignment(1.1) Specifies the vertical alignment for the object (xlVAlign)
WorksheetPositionType(1.7) Specifies the position when inserting or moving worksheets.
AggregationFunction
(1.8) Specifies the aggregation function for the data pivot field.
ArrowheadLength
(1.9) Specifies the length of the arrowhead at the end of a line (xlArrowHeadLength)
ArrowheadStyle
(1.9) Specifies the type of arrowhead to apply to the line end.
ArrowheadWidth
(1.9) Specifies the width of the arrowhead at the end of a line.
AutoFillType
(1.9) Specifies how the target range is to be filled, based on the contents of the source range (xlAutoFillType)
BindingType
(1.1)
BorderIndex
(1.1) Specifies the border to be retrieved (xlBordersIndex)
BorderLineStyle
(1.1) Specifies the line style for the border (xlLineStyle)
BorderWeight
(1.1) Specifies the weight of the border around a range (xlBorderWeight)
BuiltInPivotTableStyle
(beta)
BuiltInSlicerStyle
(beta) Specifies the built-in slicer styles.
BuiltInStyle
(1.7) Specifies the built-in cell styles.
BuiltInTableStyle
(beta) Specifies a built-in table style.
CalculationMode
(1.7) Specifies the calculation mode (xlCalculation)
CalculationState
(1.9) Specifies the calculation state across the entire Excel application (or workbook ?).
CalculationType
(1.1) Specifies the type of calculation to perform.
ChartAxisCategoryType
(1.7) Specifies the type of the category axis (xlCategoryType)
ChartAxisDisplayUnit
(1.7) Specifies the display unit label for an axis (xlDisplayUnit)
ChartAxisGroup
(1.7) Specifies the type of axis group (xlAxisGroup)
ChartAxisPosition
(1.7) Specifies the point on the specified axis where the other axis crosses (xlAxisCrosses)
ChartAxisScaleType
(1.7) Specifies the scale type of the value axis (xlScaleType)
ChartAxisTickLabelPosition
(1.7) Specifies the position of tick-mark labels on the specified axis (xlTickLabelPosition)
ChartAxisTickMark
(1.7) Specifies the position of major and minor tick marks for an axis (xlTickMark)
ChartAxisTimeUnit
(1.7) Specifies unit of time for chart axis and data series (xlTimeUnit)
ChartAxisType
(1.7) Specifies the axis type (xlAxisType)
ChartBinType
(1.9) Specifies the bin's type of a histogram chart or pareto chart series (xlBinsType)
ChartBoxQuartileCalculation
(1.9) Specifies the quartile calculation type for a chart series layout.
ChartColorScheme
(1.8)
ChartDataLabelPosition
(1.1) Specifies where the data label is positioned (xlDataLabelPosition)
ChartDisplayBlankAs
(1.8) Specifies how blank cells are plotted on a chart (xlDisplayBlankAs)
ChartErrorBarsInclude
(1.9) Specifies which error bar parts to include (xlErrorBarInclude)
ChartErrorBarsType
(1.9) Specifies the range marked by error bars (xlErrorBarType)
ChartGradientStyle
(1.9) Specifies the gradient style of a chart series.
ChartGradientStyleType
(1.9) Specifies the gradient style type of a chart series.
ChartLegendPosition
(1.1) Specifies the position of the legend on a chart (xlLegendPosition)
ChartLineStyle
(1.7) Specifies the line style for the border (xlLineStyle)
ChartMapAreaLevel
(1.9) Specifies the mapping level of a chart series.
ChartMapLabelStrategy
(1.9) Specifies the region level of a chart series.
ChartMapProjectionType
(1.9) Specifies the region projection type of a chart series.
ChartMarkerStyle
(1.7) Specifies the marker style for a point or series in a line chart, scatter chart or radar chart (xlMarkerStyle)
ChartParentLabelStrategy
(1.9) Specifies the parent label strategy of a chart series layout.
ChartPlotAreaPosition
(1.8) Specifies the position of the plot area.
ChartPlotBy
(1.8) Specifies whether the values corresponding to a particular data series are in rows or columns (xlRowCol)
ChartSeriesBy
(1.1) Specifies whether the series are by rows or by columns.
ChartSeriesDimension
(beta) Specifies the dimensions when getting values from chart series.
ChartSplitType
(1.8)
ChartTextHorizontalAlignment
(1.7) Specifies the horizontal alignment for the object (xlHAlign)
ChartTextVerticalAlignment
(1.7) Specifies the vertical alignment for the object (xlVAlign)
ChartTickLabelAlignment
(1.8) Specifies the alignment for chart tick labels.
ChartTitlePosition
(1.7) Specifies the position of the chart title.
ChartTrendlineType
(1.7) Specifies how the trendline that smoothes out fluctuations in the data is calculated (xlTrendlineType)
ChartType
(1.1) Specifies the chart type (xlChartType)
ChartUnderlineStyle
(1.1) Specifies the type of underline applied to a font (xlUnderlineStyle)
ClearApplyTo
(beta)
CloseBehavior
(1.9) Specifies the close behavior for the workbook.close event.
CommentChangeType
(1.12) Specifies how the comments in the event were changed.
ConditionalCellValueOperator
(1.6) Specifies the operator of the text conditional format type.
ConditionalDataBarAxisFormat
(1.6) Specifies the format options for a data bar axis.
ConditionalDataBarDirection
(1.6) Specifies the data bar direction within the cell.
ConditionalFormatColorCriterionType
(1.6) Specifies the type of conditional format values.
ConditionalFormatDirection
(1.6) Specifies the direction for a selection.
ConditionalFormatIconRuleType
(1.6) Specifies the type of rules for icon conditional formatting.
ConditionalFormatPresetCriterion
(1.6) Specifies the criteria for the preset criteria conditional format type.
ConditionalFormatRuleType
(1.6) Specifies the type of rules for conditional formatting.
ConditionalFormatType
(1.6) Specifies the different types of conditional formatting.
ConditionalIconCriterionOperator
(1.6) Specifies the operator for each icon criteria.
ConditionalRangeBorderIndex
(1.6) Specifies the type of border applied.
ConditionalRangeBorderLineStyle
(1.6) Specifies the type of line style applied to the border.
ConditionalRangeFontUnderlineStyle
(1.6) Specifies the type of underline applied to the font.
ConditionalTextOperator
(1.6) Specifies the operator for the text conditional format type.
ConditionalTopBottomCriterionType
(1.6) Specifies the criteria for the above/below average conditional format type.
ConnectorType
(1.9) Specifies the type of connector.
ContentType
(1.10) Specifies the different content types.
CustomFunctionMetadataFormat
(beta)
CustomFunctionType
(beta)
DataChangeType
(1.7) Specifies the different triggers for a data changed event.
DataValidationAlertStyle
(1.8) Specifies the icon used in message boxes displayed during validation (xlDVAlertStyle)
DataValidationOperator
(1.8) Specifies the operator to use for data validation.
DataValidationType
(1.8) Specifies the type of validation test to be performed in conjunction with values (xlDVType)
DateFilterCondition
(1.12) Specifies all accepted conditions by which a date filter can be applied.
DeleteShiftDirection
(1.1) Specifies how to shift cells to replace deleted cells (xlDeleteShiftDirection)
DocumentPropertyItem
(1.7) Specifies the document property items.
DocumentPropertyType
(1.7) Specifies the data type of the document property.
DynamicFilterCriteria
(1.2)
ErrorCodes
(beta)
EventSource
(1.7) Specifies the source of the event.
EventTriggerSource
(beta)
EventType
(1.7) Specifies the different types of event.
FillPattern
(1.9) Specifies the interior pattern of a cell or object (xlPattern)
FilterDatetimeSpecificity
(1.2) Specifies the different components of a date and time.
FilterOn
(1.2)
FilterOperator
(1.2) Specifies the type of opertor to use for the filter.
GeometricShapeType
(1.9) Specifies the shape type for a geometric shape object.
GroupOption
(1.10)
HeaderFooterState
(1.9) Specifies the type of header.
HorizontalAlignment
(1.1) Specifies the horizontal alignment for the object (xlHAlign)
IconSet
(1.2) Specifies the type of icon set (xlIconSet)
ImageFittingMode
(1.2)
InsertShiftDirection
(1.1) Specifies the direction in which to shift cells during an insertion (xlInsertShiftDirection)
KeyboardDirection
(1.3)
LabelFilterCondition
(1.12) Specifies all accepted conditions by which a label filter can be applied.
LinkedDataTypeRefreshMode
(beta)
LinkedDataTypeState
(1.9) Specifies the state of a linked data type.
NamedItemScope
(1.4) Specifies the scope of a named range.
NamedItemType
(1.1)
NumberFormatCategory
(1.12) Specifies the category of number formats.
PageOrientation
(1.7) Specifies the page orientation when the worksheet is printed (xlPageOrientation)
PaperType
(1.9) Specifies the size of the paper (xlPaperSize)
PictureFormat
(1.9) Specifies the type of picture file format.
PivotAxis
(1.9) Specifies the axis from which to get the PivotItems.
PivotFilterTopBottomCriterion
(1.9) Specifies the criteria for the top/bottom values filter.
PivotFilterType
(1.12) Specifies the type of filter for a PivotField.
PivotLayoutType
(1.8)
PivotTableDateGroupBy
(beta)
Placement
(1.9) Specifies the way that an object is attached to its underlying cells.
PrintComments
(1.9) Specifies where to print comments.
PrintErrorType
(1.9) Specifies the type of print error displayed (xlPrintErrors)
PrintMarginUnit
(1.9)
PrintOrder
(1.9)
ProtectionSelectionMode
(1.7)
RangeCopyType
(1.9)
RangeUnderlineStyle
(1.1) Specifies the type of underline applied to a range.
RangeValueType
(1.1)
ReadingOrder
(1.7) Specifies the reading order.
RibbonTab
(1.9) Specifies the different built-in tabs.
RowHiddenChangeType
(1.11)
SaveBehavior
(1.9) Specifies the save behavior for the workbook.save event.
SearchDirection
(1.9) Specifies the search direction when searching a range (xlSearchDirection)
ShapeAutoSize
(1.9) Specifies the type of automatic sizing allowed.
ShapeFillType
(1.9) Specifies the fill type for a shape.
ShapeFontUnderlineStyle
(1.9) Specifies the type of underline applied to a font.
ShapeLineDashStyle
(1.9) Specifies the dash style for a line.
ShapeLineStyle
(1.9) Specifies the style for a line.
ShapeScaleFrom
(1.9) Specifies which part of the shape retains its position when the shape is scaled.
ShapeScaleType
(1.9) Specifies whether the shape is scaled relative to its original or current size.
ShapeTextHorizontalAlignment
(1.9) Specifies the horizontal alignment for the text frame in a shape.
ShapeTextHorizontalOverflow
(1.9) Specifies the horizontal overflow for the text frame in a shape.
ShapeTextOrientation
(1.9) Specifies the orientation for the text frame in a shape.
ShapeTextReadingOrder
(1.9) Specifies the reading order for the text frame in a shape.
ShapeTextVerticalAlignment
(1.9) Specifies the vertical alignment for the text frame in a shape.
ShapeTextVerticalOverflow
(1.9) Specifies the vertical overflow for the text frame in a shape.
ShapeType
(1.9) Specifies the type of a shape.
ShapeZOrder
(1.9) Specifies where in the z-order a shape should be moved relative to other shapes.
SheetVisibility
(1.1) Specifies whether the worksheet is visible (xlSheetVisibility)
ShowAsCalculation
(1.8) Specifies the ShowAs Calculation function for the Data Pivot Field.
SlicerSortType
(1.10) Specifies the slicer sort behavior for Slicer.sortBy API.
SortBy
(1.8) Specifies the sort order for the specified field or range (xlSortOrder)
SortDataOption
(1.2) Specifies how to sort text (xlSortDataOption)
SortMethod
(1.2) Specifies the type of sort (xlSortMethod)
SortOn
(1.2) Specifies the parameter on which the data should be sorted (xlSortOn)
SortOrientation
(1.2) Specifies the sort orientation (xlSortOrientation)
SpecialCellType
(1.9)
SpecialCellValueType
(1.9)
SubtotalLocationType
(1.8) Specifies where the subtotal will be displayed on the worksheet (xlSubtotalLocationType)
TaskHistoryRecordType
(beta)
TopBottomSelectionType
(1.12) Specifies the filters to select whether to filter by the top N or bottom N percent, number, or sum of values.
ValueFilterCondition
(1.12) Specifies all accepted conditions by which a value filter can be applied.
VerticalAlignment
(1.1) Specifies the vertical alignment for the object (xlVAlign)
WorksheetPositionType
(1.7) Specifies the position when inserting or moving worksheets.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top