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