Other

xlAboveBelowSpecifies if the values are above or below average.
xlActionTypeSpecifies the action that should be performed.
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.
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.
xlBackgroundSpecifies the background type for text in charts.
xlBarShapeSpecifies the shape used with the 3-D bar or column chart.
xlBuiltInDialogSpecifies which dialog box to display.
xlCalcForSpecifies what should be calculated.
xlCalcMemNumberFormatTypeSpecifies the format of cell values that are based on the calculated member.
xlCategoryLabelLevelSpecifies the category labels for the category label levels.
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.
xlClipboardFormatSpecifies the format of an item on the Windows clipboard.
xlCmdTypeSpecifies the value of the commandtext property.
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.
xlConnectionTypeSpecifies the type of database connection.
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.
xlDeleteShiftDirectionSpecifies how to shift cells to replace deleted cells.
xlDirectionSpecifies the direction in which to move.
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.
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.
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.
xlFormatFilterTypesSpecifies the types of format filters.
xlFormControlSpecifies the type of the form control.
xlFormulaLabelSpecifies the formula label type for the specified range.
xlGenerateTableRefsSpecifies the type of table references.
xlHebrewModesSpecifies the mode for the Hebrew spelling checker.
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.
xlLayoutRowTypeSpecifies the type of layout row.
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.
xlListObjectSourceTypeSpecifies the current source of the list.
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.
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.
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.
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.
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.
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.
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.
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.
xlRemoveDocInfoTypeSpecifies the type information to be removed from the document information.
xlRoutingSlipDeliverySpecifies the routing delivery method.
xlRoutingSlipStatusSpecifies the status of the routing slip.
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.
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.
xlSeriesNameLevelSpecifies the series labels for the series label levels.
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.
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.
xlThreadModeSpecifies the control over the multi-threaded calculation mode.
xlTimelineLevelSpecifies the time line to be used in the slicer.
xlTimeMoving(Removed in 2016)
xlTimePeriodsSpecifies the time period.
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.
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.
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.
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.
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.
xlBackground
Specifies the background type for text in charts.
xlBarShape
Specifies the shape used with the 3-D bar or column chart.
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.
xlCategoryLabelLevel
Specifies the category labels for the category label levels.
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.
xlClipboardFormat
Specifies the format of an item on the Windows clipboard.
xlCmdType
Specifies the value of the commandtext property.
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.
xlConnectionType
Specifies the type of database connection.
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.
xlDeleteShiftDirection
Specifies how to shift cells to replace deleted cells.
xlDirection
Specifies the direction in which to move.
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.
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.
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.
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.
xlGenerateTableRefs
Specifies the type of table references.
xlHebrewModes
Specifies the mode for the Hebrew spelling checker.
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.
xlLayoutRowType
Specifies the type of layout row.
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.
xlListObjectSourceType
Specifies the current source of the list.
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.
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.
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.
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.
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.
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.
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.
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.
xlRemoveDocInfoType
Specifies the type information to be removed from the document information.
xlRoutingSlipDelivery
Specifies the routing delivery method.
xlRoutingSlipStatus
Specifies the status of the routing slip.
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.
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.
xlSeriesNameLevel
Specifies the series labels for the series label levels.
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.
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.
xlThreadMode
Specifies the control over the multi-threaded calculation mode.
xlTimelineLevel
Specifies the time line to be used in the slicer.
xlTimeMoving
(Removed in 2016)
xlTimePeriods
Specifies the time period.
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.
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.
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.

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