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