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)
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)
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.
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)
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)
ContentType(1.10)
CustomFunctionMetadataFormat(beta)
CustomFunctionType(beta)
DataChangeType(1.7)
DataValidationAlertStyle(1.8) Specifies the icon used in message boxes displayed during validation (xlDVAlertStyle)
DataValidationOperator(1.8)
DataValidationType(1.8) Specifies the type of validation test to be performed in conjunction with values (xlDVType)
DateFilterCondition(beta)
DeleteShiftDirection(1.1)
DocumentPropertyItem(1.7)
DocumentPropertyType(1.7)
DynamicFilterCriteria(1.2)
ErrorCodes(beta)
EventSource(1.7)
EventType(1.7)
FillPattern(1.9) Specifies the interior pattern of a cell or object (xlPattern)
FilterDatetimeSpecificity(1.2)
FilterOn(1.2)
FilterOperator(1.2)
GeometricShapeType(1.9) Specifies the shape type for a geometric shape object.
GroupOption(beta)
HeaderFooterState(1.9)
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)
LabelFilterCondition(beta)
LinkedDataTypeState(1.9)
NamedItemScope(1.4)
NamedItemType(beta)
NumberFormatCategory(beta)
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)
PivotAxis(1.9)
PivotFilterTopBottomCriterion(1.9)
PivotFilterType(beta) Specifies the type of filter for a PivotField.
PivotLayoutType(1.8)
Placement(1.9)
PrintComments(1.9)
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(beta)
ReadingOrder(1.7)
RibbonTab(1.9) Specifies the different built-in tabs.
RowHiddenChangeType(beta)
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)
ShapeFillType(1.9)
ShapeFontUnderlineStyle(1.9)
ShapeLineDashStyle(1.9)
ShapeLineStyle(1.9)
ShapeScaleFrom(1.9)
ShapeScaleType(1.9)
ShapeTextHorizontalAlignment(1.9)
ShapeTextHorizontalOverflow(1.9)
ShapeTextOrientation(1.9)
ShapeTextReadingOrder(1.9)
ShapeTextVerticalAlignment(1.9)
ShapeTextVerticalOverflow(1.9)
ShapeType(1.9)
ShapeZOrder(1.9)
SheetVisibility(1.1) Specifies whether the worksheet is visible (xlSheetVisibility)
ShowAsCalculation(1.8)
SlicerSortType(beta)
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)
TopBottomSelectionType(beta)
ValueFilterCondition(beta)
VerticalAlignment(1.1) Specifies the vertical alignment for the object (xlVAlign)
WorksheetPositionType(1.7)
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)
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)
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.
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)
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)
ContentType
(1.10)
CustomFunctionMetadataFormat
(beta)
CustomFunctionType
(beta)
DataChangeType
(1.7)
DataValidationAlertStyle
(1.8) Specifies the icon used in message boxes displayed during validation (xlDVAlertStyle)
DataValidationOperator
(1.8)
DataValidationType
(1.8) Specifies the type of validation test to be performed in conjunction with values (xlDVType)
DateFilterCondition
(beta)
DeleteShiftDirection
(1.1)
DocumentPropertyItem
(1.7)
DocumentPropertyType
(1.7)
DynamicFilterCriteria
(1.2)
ErrorCodes
(beta)
EventSource
(1.7)
EventType
(1.7)
FillPattern
(1.9) Specifies the interior pattern of a cell or object (xlPattern)
FilterDatetimeSpecificity
(1.2)
FilterOn
(1.2)
FilterOperator
(1.2)
GeometricShapeType
(1.9) Specifies the shape type for a geometric shape object.
GroupOption
(beta)
HeaderFooterState
(1.9)
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)
LabelFilterCondition
(beta)
LinkedDataTypeState
(1.9)
NamedItemScope
(1.4)
NamedItemType
(beta)
NumberFormatCategory
(beta)
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)
PivotAxis
(1.9)
PivotFilterTopBottomCriterion
(1.9)
PivotFilterType
(beta) Specifies the type of filter for a PivotField.
PivotLayoutType
(1.8)
Placement
(1.9)
PrintComments
(1.9)
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
(beta)
ReadingOrder
(1.7)
RibbonTab
(1.9) Specifies the different built-in tabs.
RowHiddenChangeType
(beta)
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)
ShapeFillType
(1.9)
ShapeFontUnderlineStyle
(1.9)
ShapeLineDashStyle
(1.9)
ShapeLineStyle
(1.9)
ShapeScaleFrom
(1.9)
ShapeScaleType
(1.9)
ShapeTextHorizontalAlignment
(1.9)
ShapeTextHorizontalOverflow
(1.9)
ShapeTextOrientation
(1.9)
ShapeTextReadingOrder
(1.9)
ShapeTextVerticalAlignment
(1.9)
ShapeTextVerticalOverflow
(1.9)
ShapeType
(1.9)
ShapeZOrder
(1.9)
SheetVisibility
(1.1) Specifies whether the worksheet is visible (xlSheetVisibility)
ShowAsCalculation
(1.8)
SlicerSortType
(beta)
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)
TopBottomSelectionType
(beta)
ValueFilterCondition
(beta)
VerticalAlignment
(1.1) Specifies the vertical alignment for the object (xlVAlign)
WorksheetPositionType
(1.7)

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