Complete List

xlAboveBelowSpecifies if the values are above or below average.
xlActionTypeSpecifies the action that should be performed.
xlAllocationSpecifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
xlAllocationMethodSpecifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlAllocationValueSpecifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlApplicationInternationalSpecifies country/region and international settings.
xlApplyNamesOrderSpecifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
xlArabicModesSpecifies spelling rules for the Arabic spelling checker.
xlArrangeStyleSpecifies how windows are arranged on the screen.
xlArrowHeadLengthSpecifies the length of the arrowhead at the end of a line.
xlArrowHeadStyleSpecifies the type of arrowhead to apply to the line end.
xlArrowHeadWidthSpecifies the width of the arrowhead at the line end.
xlAutoFillTypeSpecifies how the target range is to be filled, based on the contents of the source range.
xlAutoFilterOperatorSpecifies the operator to use to associate two criteria applied by a filter.
xlAxisCrossesSpecifies the point on the specified axis where the other axis crosses.
xlAxisGroupSpecifies the type of axis group.
xlAxisTypeSpecifies the axis type.
xlBackgroundSpecifies the background type for text in charts.
xlBarShapeSpecifies the shape used with the 3-D bar or column chart.
xlBinsTypeSpecifies the values passed to and returned from the ChartGroup.BinsType property.
xlBordersIndexSpecifies the border to be retrieved.
xlBorderWeightSpecifies the weight of the border around a range.
xlBuiltInDialogSpecifies which dialog box to display.
xlCalcForSpecifies what should be calculated.
xlCalcMemNumberFormatTypeSpecifies the format of cell values that are based on the calculated member.
xlCalculatedMemberTypeSpecifies the type of a calculated member in a pivot table.
xlCalculationSpecifies the calculation mode.
xlCalculationInterruptKeySpecifies which key interrupts recalculation.
xlCalculationStateSpecifies the calculation state of the application.
xlCategoryLabelLevelSpecifies the category labels for the category label levels.
xlCategorySortOrderSpecifies the sort order for the category.
xlCategoryTypeSpecifies the type of the category axis.
xlCellChangedStateSpecifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed.
xlCellInsertionModeSpecifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
xlCellTypeSpecifies the type of cells.
xlChartElementPositionSpecifies the position of the chart element.
xlChartGallerySpecifies a chart gallery.
xlChartItemSpecifies the type of the chart item.
xlChartLocationSpecifies where to relocate a chart.
xlChartPicturePlacementSpecifies the placement of a user-selected picture on a bar in a 3-D bar or column.
xlChartPictureTypeSpecifies how pictures are displayed on a column, bar picture chart, or legend key.
xlChartSplitTypeSpecifies the values displayed in the second chart in a pie chart or a bar of pie chart.
xlChartTypeSpecifies the chart type.
XlCheckInVersionTypeSpecifies the type of version for the document checked in when using the CheckIn method.
xlClipboardFormatSpecifies the format of an item on the Windows clipboard.
xlCmdTypeSpecifies the value of the commandtext property.
xlColorIndexSpecifies the colour of the interior pattern as an index into the current colour palette.
xlColumnDataTypeSpecifies how a column is to be parsed.
xlCommandUnderlinesSpecifies the state of the command underlines in Excel for the Macintosh.
xlCommentDisplayModeSpecifies the way cells display comments and comment indicators.
xlConditionValueTypesSpecifies the types of condition values that can be used.
xlConnectionTypeSpecifies the type of database connection.
xlConsolidationFunctionSpecifies the subtotal function.
XlContainsOperatorSpecifies the operator used in a function.
xlCopyPictureFormatSpecifies the format of the picture being copied.
xlCorruptLoadSpecifies the processing for a file when it is opened.
xlCreatorSpecifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
xlCredentialsMethodSpecifies the type of credentials method used.
xlCubeFieldSubTypeSpecifies the subtype of the CubeField.
xlCubeFieldTypeSpecifies whether the OLAP field is a hierarchy, set, or measure field.
xlCutCopyModeSpecifies the status of the Cut Copy mode (Long).
xlCVErrorSpecifies the type of error you want to raise.
xlDataBarAxisPositionSpecifies the axis position for a range of cells with conditional formatting as data bars.
xlDataBarBorderTypeSpecifies the border of a data bar.
xlDataBarFillTypeSpecifies how a data bar is filled with color.
xlDataBarNegativeColorTypeSpecifies whether to use the same border and fill color as postive data bars.
xlDataLabelPositionSpecifies where the data label is positioned.
xlDataLabelSeparatorSpecifies the separator used with data labels.
xlDataLabelsTypeSpecifies the type of data label to apply.
xlDataSeriesDateSpecifies the type of date to apply to a data series.
xlDataSeriesTypeSpecifies the data series to create.
xlDeleteShiftDirectionSpecifies how to shift cells to replace deleted cells.
xlDirectionSpecifies the direction in which to move.
xlDisplayBlanksAsSpecifies how blank cells are plotted on a chart.
xlDisplayDrawingObjectsSpecifies how shapes are displayed.
xlDisplayUnitSpecifies the display unit label for an axis.
xlDupeUniqueSpecifies whether duplicate or unique values shoud be displayed.
xlDVAlertStyleSpecifies the icon used in message boxes displayed during validation.
xlDVTypeSpecifies the type of validation test to be performed in conjunction with values.
xlDynamicFilterCriteriaSpecifies the filter criterion.
xlEditionFormatSpecifies the format of the published edition.
xlEditionOptionsOptionThis enumeration is for Macintosh only and should not be used.
xlEditionTypeSpecifies the type of edition to be changed.
xlEnableCancelKeySpecifies how Microsoft Excel handles Ctrl + Break (or Esc or Command + Period) user interruptions to the running procedure.
xlEnableSelectionSpecifies what can be selected on the sheet.
xlEndStyleCapSpecifies the end style for error bars.
xlErrorBarDirectionSpecifies which axis values are to receive error bars.
xlErrorBarIncludeSpecifies which error bar parts to include.
xlErrorBarTypeSpecifies the range marked by error bars.
xlErrorChecksSpecifies the type of error object to be retrieved from the Errors collection.
xlFileAccessSpecifies the new access mode for the object.
xlFileFormatSpecifies the file format when saving the spreadsheet.
xlFileValidationPivotModeSpecifies how to validate the data caches for PivotTable reports.
xlFillWithSpecifies how to copy the range.
xlFilterActionSpecifies whether data is to be copied or left in place during a filter operation.
xlFilterAllDatesInPeriodSpecifies how dates should be filtered in the specified period.
xlFilterStatusSpecifies the status of the filter.
xlFindLookInSpecifies the type of data to search.
xlFixedFormatQualitySpecifies the quality of speadsheets saved in different fixed formats.
xlFixedFormatTypeSpecifies the type of file format.
xlForecastAggregationSpecifies the type of aggregation to use for the forecast.
xlForecastChartTypeSpecifies the type of chart displayed for the forecast.
xlForecastDataCompletionSpecifies how data is completed for the forecast.
xlFormatConditionOperatorSpecifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
xlFormatConditionTypeSpecifies whether the conditional format is based on a cell value or an expression.
xlFormatFilterTypesSpecifies the types of format filters.
xlFormControlSpecifies the type of the form control.
xlFormulaLabelSpecifies the formula label type for the specified range.
xlFormulaVersionSpecifies how you want formulas replaced when using Range.Replace.
xlGenerateTableRefsSpecifies the type of table references.
xlGeoMappingLevelSpecifies the geography mapping level for a series within a chart group.
xlGeoProjectionTypeSpecifies the geography projection type for a series within the chart group.
xlGradientFillTypeSpecifies the type of gradient fill.
xlGradientStopPositionTypeSpecifies the type of gradient stop position.
xlHAlignSpecifies the horizontal alignment for the object.
xlHebrewModesSpecifies the mode for the Hebrew spelling checker.
xlHighlightChangesTimeSpecifies which set of changes is shown in a shared workbook.
xlHtmlTypeSpecifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive.
xlIconSpecifies the icon for a criterion in an icon set conditional formatting rule.
xlIconSetSpecifies the type of icon set.
xlIMEModeSpecifies the description of the Japanese input rules.
xlImportDataAsSpecifies the format in which to return data from a database.
xlInsertFormatOriginSpecifies from where to copy the format for inserted rows.
xlInsertShiftDirectionSpecifies the direction in which to shift cells during an insertion.
xlLayoutFormTypeSpecifies the way the specified PivotTable items appear in table format or in outline format.
xlLayoutRowTypeSpecifies the type of layout row.
xlLegendPositionSpecifies the position of the legend on a chart.
xlLineStyleSpecifies the line style for the border.
xlLinkSpecifies the type of link.
xlLinkedDataTypeStateSpecifies the state of cells that may contain Linked data types such as Stocks or Geography.
xlLinkInfoSpecifies the type of information to be returned.
xlLinkInfoTypeSpecifies the type of link.
xlLinkStatusSpecifies the status of a link.
xlLinkTypeSpecifies the type of link.
xlListConflictSpecifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet.
xlListDataTypeSpecifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
xlListObjectSourceTypeSpecifies the current source of the list.
xlLocationInTableSpecifies the part of the PivotTable report that contains the upper-left corner of a range.
xlLookAtSpecifies whether a match is made against the whole of the search text or any part of the search text.
xlLookForSpecifies what to look for in searches.
xlMailSystemSpecifies the mail system that is installed on the host machine.
xlMarkerStyleSpecifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
xlMeasurementUnitsSpecifies the measurement units.
xlModelChangeSourceSpecifies the source of the change to the data model.
xlMouseButtonSpecifies which mouse button was pressed.
xlMousePointerSpecifies the appearance of the mouse pointer in Microsoft Excel.
xlMSApplicationSpecifies a Microsoft application.
xlOartHorizontalOverflowSpecifies the horizontal overflow setting for a text frame.
xlOartVerticalOverflowSpecifies the vertical overflow setting for a text frame.
xlObjectSizeSpecifies the way a chart is scaled to fit on a page.
xlOLETypeSpecifies the OLE object type.
xlOLEVerbSpecifies the verb that the server of the OLE object should act on.
xlOrderSpecifies the order in which cells are processed.
xlOrientationSpecifies the text orientation.
xlPageBreakSpecifies page break location in the worksheet.
xlPageBreakExtentSpecifies whether a page break is full screen or applies only within the print area.
xlPageOrientationSpecifies the page orientation when the worksheet is printed.
xlPaperSizeSpecifies the size of the paper.
xlParameterDataTypeSpecifies the data type of a query parameter.
xlParameterTypeSpecifies how to determine the value of the parameter for the specified query table.
xlParentDataLabelOptionsSpecifies the values passed to and returned from the Series.ParentDataLabelOption property.
xlPasteSpecialOperationSpecifies the operation you want to perform.
xlPasteTypeSpecifies the part of the range you want to paste.
xlPatternSpecifies the interior pattern of a cell or object.
xlPhoneticAlignmentSpecifies the alignment for phonetic text.
xlPhoneticCharacterTypeSpecifies the type of phonetic text in a cell.
xlPictureAppearanceSpecifies how the picture should be copied.
xlPictureConvertorTypeSpecifies how to convert a graphic.
xlPieSliceIndexSpecifies which position on the slice to return the coordinate of.
xlPieSliceLocationSpecifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.
xlPivotCellTypeSpecifies the PivotTable entity the cell corresponds to.
xlPivotConditionScopeSpecifies the conditional formatting applied for filtering values from the PivotTable object.
xlPivotFieldCalculationSpecifies the type of calculation performed by a data PivotField when a custom calculation is used.
xlPivotFieldDataTypeSpecifies the type of data in the PivotTable field.
xlPivotFieldOrientationSpecifies the location of the field in a PivotTable report.
xlPivotFieldRepeatLabelsSpecifies whether to repeat all field item labels in a PivotTable report.
xlPivotFilterTypeSpecifies the type of filter applied.
xlPivotFormatTypeSpecifies the type of report formatting to be applied to the specified PivotTable report.
xlPivotLineTypeSpecifies the type of the PivotLine.
xlPivotTableMissingItemsSpecifies the maximum number of unique items per PivotField allowed.
xlPivotTableSourceTypeSpecifies the source of the report data.
xlPivotTableVersionListSpecifies the Excel version number.
xlPlacementSpecifies the way an object is attached to its underlying cells.
xlPlatformSpecifies the platform that a text file originated on.
xlPortugueseReformSpecifies the mode for checking the spelling of Portuguese.
xlPrintErrorsSpecifies the type of print error displayed.
xlPrintLocationSpecifies the way comments are printed with the sheet.
xlPrioritySpecifies the priority of a SendMailer message.
xlPropertyDisplayedInSpecifies where to display the property.
xlProtectedViewCloseReasonSpecifies how the protected view window was closed.
xlProtectedViewWindowStateSpecifies the state of the protected view window.
xlPTSelectionModeSpecifies what may be selected in a pivottable during a structured selection.
xlPublishToDocsDisclosureScopeSpecifies the disclosure type when publishing a workbook to a document.
xlPublishToPBINameConflictActionSpecifies the conflict action when publishing to Power BI.
xlPublishToPBIPublishTypeSpecifies the publishing type when publishing to Power BI.
xlQueryTypeSpecifies the type of query used to populate the query table or pivottable cache.
xlQuickAnalysisModeSpecifies which top level button the callout user interface is displayed.
xlRangeAutoFormatSpecifies the predefined format when a range is automatically formatted.
xlRangeValueDataTypeSpecifies the range value data type.
xlReferenceStyleSpecifies the reference style.
xlReferenceTypeSpecifies cell reference style when a formula is being converted.
xlRegionLabelOptionsSpecifies the region labelling behavior for a series within the chart group.
xlRemoveDocInfoTypeSpecifies the type information to be removed from the document information.
xlRgbColorSpecifies the RGB color.
xlRobustConnectSpecifies how the PivotTable cache connects to its data source.
xlRoutingSlipDeliverySpecifies the routing delivery method.
xlRoutingSlipStatusSpecifies the status of the routing slip.
xlRowColSpecifies whether the values corresponding to a particular data series are in rows or columns.
xlRunAutoMacroSpecifies the automatic macro to run.
xlSaveActionSpecifies during file close if the file will be saved.
xlSaveAsAccessModeSpecifies the access mode for the save as function.
xlSaveConflictResolutionSpecifies the way conflicts are to be resolved whenever a shared workbook is updated.
xlScaleTypeSpecifies the scale type of the value axis.
xlSearchDirectionSpecifies the search direction when searching a range.
xlSearchOrderSpecifies the order in which to search the range.
xlSearchWithinSpecifies the extent of the search for the range.
xlSeriesColorGradientStyleSpecifies the colour gradient style for a series.
xlSeriesNameLevelSpecifies the series labels for the series label levels.
xlSheetTypeSpecifies the type of sheet you can insert into a workbook.
xlSheetVisibilitySpecifies whether the worksheet is visible.
xlSizeRepresentsSpecifies what the bubble size represents on a bubble chart.
xlSlicerCacheTypeSpecifies the cache type to be used in the slicer.
xlSlicerCrossFilterTypeSpecifies the type of cross filtering used by the specified slicer cache and how it is visualized.
xlSlicerSortSpecifies whether items displayed in the slicer are sorted.
xlSmartTagControlTypeSpecifies the type of smart document control displayed in the document actions task pane.
xlSmartTagDisplayModeSpecifies the display features for smart tags.
xlSortDataOptionSpecifies how to sort text.
xlSortMethodSpecifies the type of sort.
xlSortMethodOldSpecifies how to sort when using East Asian sorting methods.
xlSortOnSpecifies the parameter on which the data should be sorted.
xlSortOrderSpecifies the sort order for the specified field or range.
xlSortOrientationSpecifies the sort orientation.
xlSortTypeSpecifies which elements are to be sorted in a pivottable report.
xlSourceTypeSpecifies the type of source object.
xlSpanishModesSpecifies the mode for checking the spelling of Spanish.
xlSparklineRowColSpecifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
xlSparkScaleSpecifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
xlSparkTypeSpecifies the type of sparkline.
xlSpeakDirectionSpecifies the order in which the cells are spoken.
xlSpecialCellsValueSpecifies cells with a particular type of value to include in the result.
xlStdColorScaleSpecifies the standard color scale.
xlSubscribeToFormatSpecifies the format to use when subscribing to a published edition.
xlSubtotalLocationTypeSpecifies where the subtotal will be displayed on the worksheet.
xlSummaryColumnSpecifies the location of the summary columns in the outline.
xlSummaryReportTypeSpecifies the location of the summary columns in the outline.
xlSummaryRowSpecifies the location of the summary rows in the outline.
xlTableStyleElementTypeSpecifies the table style element used.
xlTabPositionSpecifies the first or last tab position.
xlTextParsingTypeSpecifies the column format for the data in the text file that you are importing into a query table.
xlTextQualifierSpecifies the delimiter to use to specify text.
xlTextVisualLayoutTypeSpecifies whether the visual layout of the text being imported is left-to-right or right-to-left.
xlThemeColorSpecifies the theme color to be used.
xlThemeFontSpecifies the theme font to use.
xlThreadModeSpecifies the control over the multi-threaded calculation mode.
xlTickLabelOrientationSpecifies the text orientation for tick-mark labels.
xlTickLabelPositionSpecifies the position of tick-mark labels on the specified axis.
xlTickMarkSpecifies the position of major and minor tick marks for an axis.
xlTimelineLevelSpecifies the time line to be used in the slicer.
xlTimeMovingSpecifies the period of time moving. (Removed in 2016)
xlTimePeriodsSpecifies the time period.
xlTimeUnitSpecifies unit of time for chart axis and data series.
xlToolbarProtectionSpecifies which properties of a toolbar are restricted.
xlTopBottomSpecifies the top 10 values from the top or bottom of a series of values.
xlTotalsCalculationSpecifies the type of calculation in the Totals row of a list column.
xlTrendlineTypeSpecifies how the trendline that smoothes out fluctuations in the data is calculated.
xlUnderlineStyleSpecifies the type of underline applied to a font.
xlUpdateLinksSpecifies a workbook's setting for updating embedded OLE links.
xlVAlignSpecifies the vertical alignment for the object.
xlValueSortOrderSpecifies the sort order for the values.
xlWBATemplateSpecifies the type of workbook to create.
xlWebFormattingSpecifies how much formatting from a web page is applied when a web page is imported into a query table.
xlWebSelectionTypeSpecifies whether all the table(s) on an entire web page is imported into a query table.
xlWindowStateSpecifies the state of the window.
xlWindowTypeSpecifies how the chart is displayed.
xlWindowViewSpecifies the view showing in the window.
xlXLMMacroTypeSpecifies what type of macro a name refers to or whether the name refers to a macro.
xlXmlExportResultSpecifies the results of the save or export operation.
xlXmlImportResultSpecifies whether or not the first row contains headers.
xlXmlLoadOptionSpecifies how Excel opens the XML data file.
xlYesNoGuessSpecifies whether or not the first row contains headers.
xlAboveBelow
Specifies if the values are above or below average.
xlActionType
Specifies the action that should be performed.
xlAllocation
Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
xlAllocationMethod
Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlAllocationValue
Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlApplicationInternational
Specifies country/region and international settings.
xlApplyNamesOrder
Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
xlArabicModes
Specifies spelling rules for the Arabic spelling checker.
xlArrangeStyle
Specifies how windows are arranged on the screen.
xlArrowHeadLength
Specifies the length of the arrowhead at the end of a line.
xlArrowHeadStyle
Specifies the type of arrowhead to apply to the line end.
xlArrowHeadWidth
Specifies the width of the arrowhead at the line end.
xlAutoFillType
Specifies how the target range is to be filled, based on the contents of the source range.
xlAutoFilterOperator
Specifies the operator to use to associate two criteria applied by a filter.
xlAxisCrosses
Specifies the point on the specified axis where the other axis crosses.
xlAxisGroup
Specifies the type of axis group.
xlAxisType
Specifies the axis type.
xlBackground
Specifies the background type for text in charts.
xlBarShape
Specifies the shape used with the 3-D bar or column chart.
xlBinsType
Specifies the values passed to and returned from the ChartGroup.BinsType property.
xlBordersIndex
Specifies the border to be retrieved.
xlBorderWeight
Specifies the weight of the border around a range.
xlBuiltInDialog
Specifies which dialog box to display.
xlCalcFor
Specifies what should be calculated.
xlCalcMemNumberFormatType
Specifies the format of cell values that are based on the calculated member.
xlCalculatedMemberType
Specifies the type of a calculated member in a pivot table.
xlCalculation
Specifies the calculation mode.
xlCalculationInterruptKey
Specifies which key interrupts recalculation.
xlCalculationState
Specifies the calculation state of the application.
xlCategoryLabelLevel
Specifies the category labels for the category label levels.
xlCategorySortOrder
Specifies the sort order for the category.
xlCategoryType
Specifies the type of the category axis.
xlCellChangedState
Specifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed.
xlCellInsertionMode
Specifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
xlCellType
Specifies the type of cells.
xlChartElementPosition
Specifies the position of the chart element.
xlChartGallery
Specifies a chart gallery.
xlChartItem
Specifies the type of the chart item.
xlChartLocation
Specifies where to relocate a chart.
xlChartPicturePlacement
Specifies the placement of a user-selected picture on a bar in a 3-D bar or column.
xlChartPictureType
Specifies how pictures are displayed on a column, bar picture chart, or legend key.
xlChartSplitType
Specifies the values displayed in the second chart in a pie chart or a bar of pie chart.
xlChartType
Specifies the chart type.
XlCheckInVersionType
Specifies the type of version for the document checked in when using the CheckIn method.
xlClipboardFormat
Specifies the format of an item on the Windows clipboard.
xlCmdType
Specifies the value of the commandtext property.
xlColorIndex
Specifies the colour of the interior pattern as an index into the current colour palette.
xlColumnDataType
Specifies how a column is to be parsed.
xlCommandUnderlines
Specifies the state of the command underlines in Excel for the Macintosh.
xlCommentDisplayMode
Specifies the way cells display comments and comment indicators.
xlConditionValueTypes
Specifies the types of condition values that can be used.
xlConnectionType
Specifies the type of database connection.
xlConsolidationFunction
Specifies the subtotal function.
XlContainsOperator
Specifies the operator used in a function.
xlCopyPictureFormat
Specifies the format of the picture being copied.
xlCorruptLoad
Specifies the processing for a file when it is opened.
xlCreator
Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
xlCredentialsMethod
Specifies the type of credentials method used.
xlCubeFieldSubType
Specifies the subtype of the CubeField.
xlCubeFieldType
Specifies whether the OLAP field is a hierarchy, set, or measure field.
xlCutCopyMode
Specifies the status of the Cut Copy mode (Long).
xlCVError
Specifies the type of error you want to raise.
xlDataBarAxisPosition
Specifies the axis position for a range of cells with conditional formatting as data bars.
xlDataBarBorderType
Specifies the border of a data bar.
xlDataBarFillType
Specifies how a data bar is filled with color.
xlDataBarNegativeColorType
Specifies whether to use the same border and fill color as postive data bars.
xlDataLabelPosition
Specifies where the data label is positioned.
xlDataLabelSeparator
Specifies the separator used with data labels.
xlDataLabelsType
Specifies the type of data label to apply.
xlDataSeriesDate
Specifies the type of date to apply to a data series.
xlDataSeriesType
Specifies the data series to create.
xlDeleteShiftDirection
Specifies how to shift cells to replace deleted cells.
xlDirection
Specifies the direction in which to move.
xlDisplayBlanksAs
Specifies how blank cells are plotted on a chart.
xlDisplayDrawingObjects
Specifies how shapes are displayed.
xlDisplayUnit
Specifies the display unit label for an axis.
xlDupeUnique
Specifies whether duplicate or unique values shoud be displayed.
xlDVAlertStyle
Specifies the icon used in message boxes displayed during validation.
xlDVType
Specifies the type of validation test to be performed in conjunction with values.
xlDynamicFilterCriteria
Specifies the filter criterion.
xlEditionFormat
Specifies the format of the published edition.
xlEditionOptionsOption
This enumeration is for Macintosh only and should not be used.
xlEditionType
Specifies the type of edition to be changed.
xlEnableCancelKey
Specifies how Microsoft Excel handles Ctrl + Break (or Esc or Command + Period) user interruptions to the running procedure.
xlEnableSelection
Specifies what can be selected on the sheet.
xlEndStyleCap
Specifies the end style for error bars.
xlErrorBarDirection
Specifies which axis values are to receive error bars.
xlErrorBarInclude
Specifies which error bar parts to include.
xlErrorBarType
Specifies the range marked by error bars.
xlErrorChecks
Specifies the type of error object to be retrieved from the Errors collection.
xlFileAccess
Specifies the new access mode for the object.
xlFileFormat
Specifies the file format when saving the spreadsheet.
xlFileValidationPivotMode
Specifies how to validate the data caches for PivotTable reports.
xlFillWith
Specifies how to copy the range.
xlFilterAction
Specifies whether data is to be copied or left in place during a filter operation.
xlFilterAllDatesInPeriod
Specifies how dates should be filtered in the specified period.
xlFilterStatus
Specifies the status of the filter.
xlFindLookIn
Specifies the type of data to search.
xlFixedFormatQuality
Specifies the quality of speadsheets saved in different fixed formats.
xlFixedFormatType
Specifies the type of file format.
xlForecastAggregation
Specifies the type of aggregation to use for the forecast.
xlForecastChartType
Specifies the type of chart displayed for the forecast.
xlForecastDataCompletion
Specifies how data is completed for the forecast.
xlFormatConditionOperator
Specifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
xlFormatConditionType
Specifies whether the conditional format is based on a cell value or an expression.
xlFormatFilterTypes
Specifies the types of format filters.
xlFormControl
Specifies the type of the form control.
xlFormulaLabel
Specifies the formula label type for the specified range.
xlFormulaVersion
Specifies how you want formulas replaced when using Range.Replace.
xlGenerateTableRefs
Specifies the type of table references.
xlGeoMappingLevel
Specifies the geography mapping level for a series within a chart group.
xlGeoProjectionType
Specifies the geography projection type for a series within the chart group.
xlGradientFillType
Specifies the type of gradient fill.
xlGradientStopPositionType
Specifies the type of gradient stop position.
xlHAlign
Specifies the horizontal alignment for the object.
xlHebrewModes
Specifies the mode for the Hebrew spelling checker.
xlHighlightChangesTime
Specifies which set of changes is shown in a shared workbook.
xlHtmlType
Specifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive.
xlIcon
Specifies the icon for a criterion in an icon set conditional formatting rule.
xlIconSet
Specifies the type of icon set.
xlIMEMode
Specifies the description of the Japanese input rules.
xlImportDataAs
Specifies the format in which to return data from a database.
xlInsertFormatOrigin
Specifies from where to copy the format for inserted rows.
xlInsertShiftDirection
Specifies the direction in which to shift cells during an insertion.
xlLayoutFormType
Specifies the way the specified PivotTable items appear in table format or in outline format.
xlLayoutRowType
Specifies the type of layout row.
xlLegendPosition
Specifies the position of the legend on a chart.
xlLineStyle
Specifies the line style for the border.
xlLink
Specifies the type of link.
xlLinkedDataTypeState
Specifies the state of cells that may contain Linked data types such as Stocks or Geography.
xlLinkInfo
Specifies the type of information to be returned.
xlLinkInfoType
Specifies the type of link.
xlLinkStatus
Specifies the status of a link.
xlLinkType
Specifies the type of link.
xlListConflict
Specifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet.
xlListDataType
Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
xlListObjectSourceType
Specifies the current source of the list.
xlLocationInTable
Specifies the part of the PivotTable report that contains the upper-left corner of a range.
xlLookAt
Specifies whether a match is made against the whole of the search text or any part of the search text.
xlLookFor
Specifies what to look for in searches.
xlMailSystem
Specifies the mail system that is installed on the host machine.
xlMarkerStyle
Specifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
xlMeasurementUnits
Specifies the measurement units.
xlModelChangeSource
Specifies the source of the change to the data model.
xlMouseButton
Specifies which mouse button was pressed.
xlMousePointer
Specifies the appearance of the mouse pointer in Microsoft Excel.
xlMSApplication
Specifies a Microsoft application.
xlOartHorizontalOverflow
Specifies the horizontal overflow setting for a text frame.
xlOartVerticalOverflow
Specifies the vertical overflow setting for a text frame.
xlObjectSize
Specifies the way a chart is scaled to fit on a page.
xlOLEType
Specifies the OLE object type.
xlOLEVerb
Specifies the verb that the server of the OLE object should act on.
xlOrder
Specifies the order in which cells are processed.
xlOrientation
Specifies the text orientation.
xlPageBreak
Specifies page break location in the worksheet.
xlPageBreakExtent
Specifies whether a page break is full screen or applies only within the print area.
xlPageOrientation
Specifies the page orientation when the worksheet is printed.
xlPaperSize
Specifies the size of the paper.
xlParameterDataType
Specifies the data type of a query parameter.
xlParameterType
Specifies how to determine the value of the parameter for the specified query table.
xlParentDataLabelOptions
Specifies the values passed to and returned from the Series.ParentDataLabelOption property.
xlPasteSpecialOperation
Specifies the operation you want to perform.
xlPasteType
Specifies the part of the range you want to paste.
xlPattern
Specifies the interior pattern of a cell or object.
xlPhoneticAlignment
Specifies the alignment for phonetic text.
xlPhoneticCharacterType
Specifies the type of phonetic text in a cell.
xlPictureAppearance
Specifies how the picture should be copied.
xlPictureConvertorType
Specifies how to convert a graphic.
xlPieSliceIndex
Specifies which position on the slice to return the coordinate of.
xlPieSliceLocation
Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.
xlPivotCellType
Specifies the PivotTable entity the cell corresponds to.
xlPivotConditionScope
Specifies the conditional formatting applied for filtering values from the PivotTable object.
xlPivotFieldCalculation
Specifies the type of calculation performed by a data PivotField when a custom calculation is used.
xlPivotFieldDataType
Specifies the type of data in the PivotTable field.
xlPivotFieldOrientation
Specifies the location of the field in a PivotTable report.
xlPivotFieldRepeatLabels
Specifies whether to repeat all field item labels in a PivotTable report.
xlPivotFilterType
Specifies the type of filter applied.
xlPivotFormatType
Specifies the type of report formatting to be applied to the specified PivotTable report.
xlPivotLineType
Specifies the type of the PivotLine.
xlPivotTableMissingItems
Specifies the maximum number of unique items per PivotField allowed.
xlPivotTableSourceType
Specifies the source of the report data.
xlPivotTableVersionList
Specifies the Excel version number.
xlPlacement
Specifies the way an object is attached to its underlying cells.
xlPlatform
Specifies the platform that a text file originated on.
xlPortugueseReform
Specifies the mode for checking the spelling of Portuguese.
xlPrintErrors
Specifies the type of print error displayed.
xlPrintLocation
Specifies the way comments are printed with the sheet.
xlPriority
Specifies the priority of a SendMailer message.
xlPropertyDisplayedIn
Specifies where to display the property.
xlProtectedViewCloseReason
Specifies how the protected view window was closed.
xlProtectedViewWindowState
Specifies the state of the protected view window.
xlPTSelectionMode
Specifies what may be selected in a pivottable during a structured selection.
xlPublishToDocsDisclosureScope
Specifies the disclosure type when publishing a workbook to a document.
xlPublishToPBINameConflictAction
Specifies the conflict action when publishing to Power BI.
xlPublishToPBIPublishType
Specifies the publishing type when publishing to Power BI.
xlQueryType
Specifies the type of query used to populate the query table or pivottable cache.
xlQuickAnalysisMode
Specifies which top level button the callout user interface is displayed.
xlRangeAutoFormat
Specifies the predefined format when a range is automatically formatted.
xlRangeValueDataType
Specifies the range value data type.
xlReferenceStyle
Specifies the reference style.
xlReferenceType
Specifies cell reference style when a formula is being converted.
xlRegionLabelOptions
Specifies the region labelling behavior for a series within the chart group.
xlRemoveDocInfoType
Specifies the type information to be removed from the document information.
xlRgbColor
Specifies the RGB color.
xlRobustConnect
Specifies how the PivotTable cache connects to its data source.
xlRoutingSlipDelivery
Specifies the routing delivery method.
xlRoutingSlipStatus
Specifies the status of the routing slip.
xlRowCol
Specifies whether the values corresponding to a particular data series are in rows or columns.
xlRunAutoMacro
Specifies the automatic macro to run.
xlSaveAction
Specifies during file close if the file will be saved.
xlSaveAsAccessMode
Specifies the access mode for the save as function.
xlSaveConflictResolution
Specifies the way conflicts are to be resolved whenever a shared workbook is updated.
xlScaleType
Specifies the scale type of the value axis.
xlSearchDirection
Specifies the search direction when searching a range.
xlSearchOrder
Specifies the order in which to search the range.
xlSearchWithin
Specifies the extent of the search for the range.
xlSeriesColorGradientStyle
Specifies the colour gradient style for a series.
xlSeriesNameLevel
Specifies the series labels for the series label levels.
xlSheetType
Specifies the type of sheet you can insert into a workbook.
xlSheetVisibility
Specifies whether the worksheet is visible.
xlSizeRepresents
Specifies what the bubble size represents on a bubble chart.
xlSlicerCacheType
Specifies the cache type to be used in the slicer.
xlSlicerCrossFilterType
Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.
xlSlicerSort
Specifies whether items displayed in the slicer are sorted.
xlSmartTagControlType
Specifies the type of smart document control displayed in the document actions task pane.
xlSmartTagDisplayMode
Specifies the display features for smart tags.
xlSortDataOption
Specifies how to sort text.
xlSortMethod
Specifies the type of sort.
xlSortMethodOld
Specifies how to sort when using East Asian sorting methods.
xlSortOn
Specifies the parameter on which the data should be sorted.
xlSortOrder
Specifies the sort order for the specified field or range.
xlSortOrientation
Specifies the sort orientation.
xlSortType
Specifies which elements are to be sorted in a pivottable report.
xlSourceType
Specifies the type of source object.
xlSpanishModes
Specifies the mode for checking the spelling of Spanish.
xlSparklineRowCol
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
xlSparkScale
Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
xlSparkType
Specifies the type of sparkline.
xlSpeakDirection
Specifies the order in which the cells are spoken.
xlSpecialCellsValue
Specifies cells with a particular type of value to include in the result.
xlStdColorScale
Specifies the standard color scale.
xlSubscribeToFormat
Specifies the format to use when subscribing to a published edition.
xlSubtotalLocationType
Specifies where the subtotal will be displayed on the worksheet.
xlSummaryColumn
Specifies the location of the summary columns in the outline.
xlSummaryReportType
Specifies the location of the summary columns in the outline.
xlSummaryRow
Specifies the location of the summary rows in the outline.
xlTableStyleElementType
Specifies the table style element used.
xlTabPosition
Specifies the first or last tab position.
xlTextParsingType
Specifies the column format for the data in the text file that you are importing into a query table.
xlTextQualifier
Specifies the delimiter to use to specify text.
xlTextVisualLayoutType
Specifies whether the visual layout of the text being imported is left-to-right or right-to-left.
xlThemeColor
Specifies the theme color to be used.
xlThemeFont
Specifies the theme font to use.
xlThreadMode
Specifies the control over the multi-threaded calculation mode.
xlTickLabelOrientation
Specifies the text orientation for tick-mark labels.
xlTickLabelPosition
Specifies the position of tick-mark labels on the specified axis.
xlTickMark
Specifies the position of major and minor tick marks for an axis.
xlTimelineLevel
Specifies the time line to be used in the slicer.
xlTimeMoving
Specifies the period of time moving. (Removed in 2016)
xlTimePeriods
Specifies the time period.
xlTimeUnit
Specifies unit of time for chart axis and data series.
xlToolbarProtection
Specifies which properties of a toolbar are restricted.
xlTopBottom
Specifies the top 10 values from the top or bottom of a series of values.
xlTotalsCalculation
Specifies the type of calculation in the Totals row of a list column.
xlTrendlineType
Specifies how the trendline that smoothes out fluctuations in the data is calculated.
xlUnderlineStyle
Specifies the type of underline applied to a font.
xlUpdateLinks
Specifies a workbook's setting for updating embedded OLE links.
xlVAlign
Specifies the vertical alignment for the object.
xlValueSortOrder
Specifies the sort order for the values.
xlWBATemplate
Specifies the type of workbook to create.
xlWebFormatting
Specifies how much formatting from a web page is applied when a web page is imported into a query table.
xlWebSelectionType
Specifies whether all the table(s) on an entire web page is imported into a query table.
xlWindowState
Specifies the state of the window.
xlWindowType
Specifies how the chart is displayed.
xlWindowView
Specifies the view showing in the window.
xlXLMMacroType
Specifies what type of macro a name refers to or whether the name refers to a macro.
xlXmlExportResult
Specifies the results of the save or export operation.
xlXmlImportResult
Specifies whether or not the first row contains headers.
xlXmlLoadOption
Specifies how Excel opens the XML data file.
xlYesNoGuess
Specifies whether or not the first row contains headers.

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