Other
| 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. |
| xlCategorySortOrder | Specifies the sort order for the category. |
| 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. |
| 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. |
| xlFormulaVersion | Specifies how you want formulas replaced when using Range.Replace. |
| 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. |
| xlLinkedDataTypeState | Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| 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. |
| 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. |
| 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. |
| xlSeriesColorGradientStyle | Specifies the colour gradient style for a series. |
| 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 | (Compatibility) Specifies the type of smart document control displayed in the document actions task pane. |
| xlSmartTagDisplayMode | (Compatibility) 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. |
| 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. |
| 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. |
| xlValueSortOrder | Specifies the sort order for the values. |
| 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. |
| 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. |
| xlCategorySortOrder Specifies the sort order for the category. |
| 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. |
| 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. |
| xlFormulaVersion Specifies how you want formulas replaced when using Range.Replace. |
| 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. |
| xlLinkedDataTypeState Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| 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. |
| 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. |
| 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. |
| xlSeriesColorGradientStyle Specifies the colour gradient style for a series. |
| 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 (Compatibility) Specifies the type of smart document control displayed in the document actions task pane. |
| xlSmartTagDisplayMode (Compatibility) 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. |
| 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. |
| 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. |
| xlValueSortOrder Specifies the sort order for the values. |
| 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. |
xlAboveBelow |
| Specifies if the values are above or below average. |
| XlAboveAverage | Above average (0) |
| XlAboveStdDev | Above standard deviation (4) |
| XlBelowAverage | Below average (1) |
| XlBelowStdDev | Below standard deviation (5) |
| XlEqualAboveAverage | Equal above average (2) |
| XlEqualBelowAverage | Equal below average (3) |
| XlAboveAverage |
| Above average (0) |
| XlAboveStdDev |
| Above standard deviation (4) |
| XlBelowAverage |
| Below average (1) |
| XlBelowStdDev |
| Below standard deviation (5) |
| XlEqualAboveAverage |
| Equal above average (2) |
| XlEqualBelowAverage |
| Equal below average (3) |
| REMARKS |
| * Added in 2007. |
xlActionType |
| Specifies the action that should be performed. |
| xlActionTypeDrillthrough | Drill through (256) |
| xlActionTypeReport | Report (128) |
| xlActionTypeRowset | Rowset (16) |
| xlActionTypeUrl | URL (1) |
| xlActionTypeDrillthrough |
| Drill through (256) |
| xlActionTypeReport |
| Report (128) |
| xlActionTypeRowset |
| Rowset (16) |
| xlActionTypeUrl |
| URL (1) |
| REMARKS |
| * Added in 2007. |
xlApplicationInternational |
| Specifies country/region and international settings. |
| xl24HourClock | 24-hour time or 12 hour time (33) |
| xl4DigitYears | Four digit year or 2-digit year (43) |
| xlAlternateArraySeparator | Alternate array item separator to be used if the current array separator is the same as the decimal separator (16) |
| xlColumnSeparator | Character used to separate columns in array literals (14) |
| xlCountryCode | Country/Region version of Microsoft Excel (1) |
| xlCountrySetting | Current country/region setting in the Windows Control Panel (2) |
| xlCurrencyBefore | Does the currency symbol precede the currency value (37) |
| xlCurrencyCode | Currency symbol (25) |
| xlCurrencyDigits | Number of decimal digits to be used in currency formats (27) |
| xlCurrencyLeadingZeros | Are leading zeros displayed for zero currency values (40) |
| xlCurrencyMinusSign | Is a minus sign used for negative values (38) |
| xlCurrencyNegative | Currency format for negative values (28) |
| xlCurrencySpaceBefore | Is a space added before the currency symbol (36) |
| xlCurrencyTrailingZeros | Are trailing zeros displayed for zero currency values (39) |
| xlDateOrder | Order of date elements (32) |
| xlDateSeparator | Date separator (17) |
| xlDayCode | Day symbol (21) |
| xlDayLeadingZero | Are leading zeros displayed for days (42) |
| xlDecimalSeparator | Decimal separator (3) |
| xlGeneralFormatName | Name of the General number format (26) |
| xlHourCode | Hour symbol (22) |
| xlLeftBrace | Character used instead of the left brace ({) in array literals (12) |
| xlLeftBracket | Character used instead of the left bracket ([) in R1C1-style relative references (10) |
| xlListSeparator | List separator (5) |
| xlLowerCaseColumnLetter | Lowercase column letter (9) |
| xlLowerCaseRowLetter | Lowercase row letter (8) |
| xlMDY | Is the date order month-day-year for dates displayed in the long form (44) |
| xlMetric | Are you using the metric system or the imperial system (35) |
| xlMinuteCode | Minute symbol (23) |
| xlMonthCode | Month symbol (20) |
| xlMonthLeadingZero | Are leading zeros displayed for months when they are displayed as numbers (41) |
| xlMonthNameChars | Always returns three characters for backwards compatibility Abbreviated month names are read from Microsoft Windows and can be any length (30) |
| xlNoncurrencyDigits | Number of decimal digits to be used in noncurrency format (29) |
| xlNonEnglishFunctions | Are you displaying functions in English (34) |
| xlRightBrace | Character used instead of the right brace (}) in array literals (13) |
| xlRightBracket | Character used instead of the right bracket ([) in R1C1 style references (11) |
| xlRowSeparator | Character used to separate rows in array literals (15) |
| xlSecondCode | Second symbol (24) |
| xlThousandsSeparator | Zero or thousands separator (4) |
| xlTimeLeadingZero | Are leading zeros displayed in times (45) |
| xlTimeSeparator | Time separator (18) |
| xlUpperCaseColumnLetter | Uppercase column letter (7) |
| xlUpperCaseRowLetter | Uppercase row letter (6) |
| xlWeekdayNameChars | Always returns three characters for backward compatibility Abbreviated weekday names are read from Microsoft Windows and can be any length (31) |
| xlYearCode | Year symbol in number format (19) |
| xl24HourClock |
| 24-hour time or 12 hour time (33) |
| xl4DigitYears |
| Four digit year or 2-digit year (43) |
| xlAlternateArraySeparator |
| Alternate array item separator to be used if the current array separator is the same as the decimal separator (16) |
| xlColumnSeparator |
| Character used to separate columns in array literals (14) |
| xlCountryCode |
| Country/Region version of Microsoft Excel (1) |
| xlCountrySetting |
| Current country/region setting in the Windows Control Panel (2) |
| xlCurrencyBefore |
| Does the currency symbol precede the currency value (37) |
| xlCurrencyCode |
| Currency symbol (25) |
| xlCurrencyDigits |
| Number of decimal digits to be used in currency formats (27) |
| xlCurrencyLeadingZeros |
| Are leading zeros displayed for zero currency values (40) |
| xlCurrencyMinusSign |
| Is a minus sign used for negative values (38) |
| xlCurrencyNegative |
| Currency format for negative values (28) |
| xlCurrencySpaceBefore |
| Is a space added before the currency symbol (36) |
| xlCurrencyTrailingZeros |
| Are trailing zeros displayed for zero currency values (39) |
| xlDateOrder |
| Order of date elements (32) |
| xlDateSeparator |
| Date separator (17) |
| xlDayCode |
| Day symbol (21) |
| xlDayLeadingZero |
| Are leading zeros displayed for days (42) |
| xlDecimalSeparator |
| Decimal separator (3) |
| xlGeneralFormatName |
| Name of the General number format (26) |
| xlHourCode |
| Hour symbol (22) |
| xlLeftBrace |
| Character used instead of the left brace ({) in array literals (12) |
| xlLeftBracket |
| Character used instead of the left bracket ([) in R1C1-style relative references (10) |
| xlListSeparator |
| List separator (5) |
| xlLowerCaseColumnLetter |
| Lowercase column letter (9) |
| xlLowerCaseRowLetter |
| Lowercase row letter (8) |
| xlMDY |
| Is the date order month-day-year for dates displayed in the long form (44) |
| xlMetric |
| Are you using the metric system or the imperial system (35) |
| xlMinuteCode |
| Minute symbol (23) |
| xlMonthCode |
| Month symbol (20) |
| xlMonthLeadingZero |
| Are leading zeros displayed for months when they are displayed as numbers (41) |
| xlMonthNameChars |
| Always returns three characters for backwards compatibility Abbreviated month names are read from Microsoft Windows and can be any length (30) |
| xlNoncurrencyDigits |
| Number of decimal digits to be used in noncurrency format (29) |
| xlNonEnglishFunctions |
| Are you displaying functions in English (34) |
| xlRightBrace |
| Character used instead of the right brace (}) in array literals (13) |
| xlRightBracket |
| Character used instead of the right bracket ([) in R1C1 style references (11) |
| xlRowSeparator |
| Character used to separate rows in array literals (15) |
| xlSecondCode |
| Second symbol (24) |
| xlThousandsSeparator |
| Zero or thousands separator (4) |
| xlTimeLeadingZero |
| Are leading zeros displayed in times (45) |
| xlTimeSeparator |
| Time separator (18) |
| xlUpperCaseColumnLetter |
| Uppercase column letter (7) |
| xlUpperCaseRowLetter |
| Uppercase row letter (6) |
| xlWeekdayNameChars |
| Always returns three characters for backward compatibility Abbreviated weekday names are read from Microsoft Windows and can be any length (31) |
| xlYearCode |
| Year symbol in number format (19) |
| REMARKS |
| * This is used in conjunction with the Application.International property. |
xlApplyNamesOrder |
| Specifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name. |
| xlColumnThenRow | Columns listed before rows (2) |
| xlRowThenColumn | Rows listed before columns (1) |
| xlColumnThenRow |
| Columns listed before rows (2) |
| xlRowThenColumn |
| Rows listed before columns (1) |
xlArabicModes |
| Specifies spelling rules for the Arabic spelling checker. |
| xlArabicBothStrict | The spelling checker uses spelling rules regarding Arabic words ending with the letters "yaa" and starting with the "alef hamza" (3) |
| xlArabicNone | The spelling checker ignores spelling rules regarding Arabi words ending with the letters "yaa" and starting with "alef hamza" (0) |
| xlArabicStrictAlefHamza | The spelling checker uses spelling rules regarding Arabic words starting with "alef hamza" (1) |
| xlArabicStrictFinalYaa | The spelling checker uses spelling rules regarding Arabic words ending with the letters "yaa" (2) |
| xlArabicBothStrict |
| The spelling checker uses spelling rules regarding Arabic words ending with the letters "yaa" and starting with the "alef hamza" (3) |
| xlArabicNone |
| The spelling checker ignores spelling rules regarding Arabi words ending with the letters "yaa" and starting with "alef hamza" (0) |
| xlArabicStrictAlefHamza |
| The spelling checker uses spelling rules regarding Arabic words starting with "alef hamza" (1) |
| xlArabicStrictFinalYaa |
| The spelling checker uses spelling rules regarding Arabic words ending with the letters "yaa" (2) |
| REMARKS |
| * Added in 2002. |
xlArrangeStyle |
| Specifies how windows are arranged on the screen. |
| xlArrangeStyleCascade | Windows are cascaded (7) |
| xlArrangeStyleHorizontal | Windows are arranged horizontally (-4128) |
| xlArrangeStyleTiled* | Windows are tiled (1) |
| xlArrangeStyleVertical | Windows are arranged vertically (-4166) |
| xlArrangeStyleCascade |
| Windows are cascaded (7) |
| xlArrangeStyleHorizontal |
| Windows are arranged horizontally (-4128) |
| xlArrangeStyleTiled* |
| Windows are tiled (1) |
| xlArrangeStyleVertical |
| Windows are arranged vertically (-4166) |
xlAutoFillType |
| Specifies how the target range is to be filled, based on the contents of the source range. |
| xlFillCopy | Copy the values and formats from the source range to the target range, repeating if necessary (1) |
| xlFillDays | Extend the names of the days of the week in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (5) |
| xlFillDefault* | Excel determines the values and formats used to fill the target range (0) |
| xlFillFormats | Copy only the formats from the source range to the target range, repeating if necessary (3) |
| xlFillMonths | Extend the names of the months in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (7) |
| xlFillSeries | Extend the values in the source range into the target range as a series (e.g., '1, 2' is extended as '3, 4, 5') Formats are copied from the source range to the target range, repeating if necessary (2) |
| xlFillValues | Copy only the values from the source range to the target range, repeating if necessary (4) |
| xlFillWeekdays | Extend the names of the days of the workweek in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (6) |
| xlFillYears | Extend the years in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (8) |
| xlFlashFill | (Added in 2013) |
| xlGrowthTrend | Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative (e.g., '1, 2,' is extended as '4, 8, 16' assuming that each number is a result of multiplying the previous number by some value) Formats are copied from the source range to the target range, repeating if necessary (10) |
| xlLinearTrend | Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers is additive (e.g., '1, 2,' is extended as '3, 4, 5' assuming that each number is a result of adding some value to the previous number) Formats are copied from the source range to the target range, repeating if necessary (9) |
| xlFillCopy |
| Copy the values and formats from the source range to the target range, repeating if necessary (1) |
| xlFillDays |
| Extend the names of the days of the week in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (5) |
| xlFillDefault* |
| Excel determines the values and formats used to fill the target range (0) |
| xlFillFormats |
| Copy only the formats from the source range to the target range, repeating if necessary (3) |
| xlFillMonths |
| Extend the names of the months in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (7) |
| xlFillSeries |
| Extend the values in the source range into the target range as a series (e.g., '1, 2' is extended as '3, 4, 5') Formats are copied from the source range to the target range, repeating if necessary (2) |
| xlFillValues |
| Copy only the values from the source range to the target range, repeating if necessary (4) |
| xlFillWeekdays |
| Extend the names of the days of the workweek in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (6) |
| xlFillYears |
| Extend the years in the source range into the target range Formats are copied from the source range to the target range, repeating if necessary (8) |
| xlFlashFill |
| (Added in 2013) |
| xlGrowthTrend |
| Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative (e.g., '1, 2,' is extended as '4, 8, 16' assuming that each number is a result of multiplying the previous number by some value) Formats are copied from the source range to the target range, repeating if necessary (10) |
| xlLinearTrend |
| Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers is additive (e.g., '1, 2,' is extended as '3, 4, 5' assuming that each number is a result of adding some value to the previous number) Formats are copied from the source range to the target range, repeating if necessary (9) |
xlAutoFilterOperator |
| Specifies the operator to use to associate two criteria applied by a filter. |
| xlAnd | Logical AND of Criteria1 and Criteria2 (1) |
| xlBottom10Items | Lowest-valued items displayed (number of items specified in Criteria1) (4) |
| xlBottom10Percent | Lowest-valued items displayed (percentage specified in Criteria1) (6) |
| xlFilterAutomaticFontColor | (Added in 2007) (13) |
| xlFilterCellColor | (Added in 2007) Color of the cell (8) |
| xlFilterDynamic | (Added in 2007) Filter dynamic (11) |
| xlFilterFontColor | (Added in 2007) Color of the font (9) |
| xlFilterIcon | (Added in 2007) Filter icon (10) |
| xlFilterNoFill | (Added in 2007) (12) |
| xlFilterNoIcon | (Added in 2007) (14) |
| xlFilterValues | (Added in 2007) Filter values (7) |
| xlOr | Logical OR of Criteria1 and Criteria2 (2) |
| xlTop10Items | Highest-valued items displayed (number of items specified in Criteria1) (3) |
| xlTop10Percent | Highest-values items displayed (percentage specified in Criteria1) (5) |
| xlAnd |
| Logical AND of Criteria1 and Criteria2 (1) |
| xlBottom10Items |
| Lowest-valued items displayed (number of items specified in Criteria1) (4) |
| xlBottom10Percent |
| Lowest-valued items displayed (percentage specified in Criteria1) (6) |
| xlFilterAutomaticFontColor |
| (Added in 2007) (13) |
| xlFilterCellColor |
| (Added in 2007) Color of the cell (8) |
| xlFilterDynamic |
| (Added in 2007) Filter dynamic (11) |
| xlFilterFontColor |
| (Added in 2007) Color of the font (9) |
| xlFilterIcon |
| (Added in 2007) Filter icon (10) |
| xlFilterNoFill |
| (Added in 2007) (12) |
| xlFilterNoIcon |
| (Added in 2007) (14) |
| xlFilterValues |
| (Added in 2007) Filter values (7) |
| xlOr |
| Logical OR of Criteria1 and Criteria2 (2) |
| xlTop10Items |
| Highest-valued items displayed (number of items specified in Criteria1) (3) |
| xlTop10Percent |
| Highest-values items displayed (percentage specified in Criteria1) (5) |
xlBackground |
| Specifies the background type for text in charts. |
| xlBackgroundAutomatic | Excel controls the background (-4105) |
| xlBackgroundOpaque | Opaque background (3) |
| xlBackgroundTransparent | Transparent background (2) |
| xlBackgroundAutomatic |
| Excel controls the background (-4105) |
| xlBackgroundOpaque |
| Opaque background (3) |
| xlBackgroundTransparent |
| Transparent background (2) |
xlBarShape |
| Specifies the shape used with the 3-D bar or column chart. |
| xlBox | Box (0) |
| xlConeToMax | Cone, truncated at value (5) |
| xlConeToPoint | Cone, coming to point at value (4) |
| xlCylinder | Cylinder (3) |
| xlPyramidToMax | Pyramid, truncated at value (2) |
| xlPyramidToPoint | Pyramid, coming to point at value (1) |
| xlBox |
| Box (0) |
| xlConeToMax |
| Cone, truncated at value (5) |
| xlConeToPoint |
| Cone, coming to point at value (4) |
| xlCylinder |
| Cylinder (3) |
| xlPyramidToMax |
| Pyramid, truncated at value (2) |
| xlPyramidToPoint |
| Pyramid, coming to point at value (1) |
xlBuiltInDialog |
| Specifies which dialog box to display. |
| xlDialogActivate | 103 |
| xlDialogActiveCellFont | 476 |
| xlDialogAddChartAutoformat | 390 |
| xlDialogAddinManager | 321 |
| xlDialogAlignment | 43 |
| xlDialogApplyNames | 133 |
| xlDialogApplyStyle | 212 |
| xlDialogAppMove | 170 |
| xlDialogAppSize | 171 |
| xlDialogArrangeAll | 12 |
| xlDialogAssignToObject | 213 |
| xlDialogAssignToTool | 293 |
| xlDialogAttachText | 80 |
| xlDialogAttachToolbars | 323 |
| xlDialogAutoCorrect | 485 |
| xlDialogAxes | 78 |
| xlDialogBorder | 45 |
| xlDialogCalculation | 32 |
| xlDialogCellProtection | 46 |
| xlDialogChangeLink | 166 |
| xlDialogChartAddData | 392 |
| xlDialogChartLocation | 527 |
| xlDialogChartOptionsDataLabelMultiple | 724 |
| xlDialogChartOptionsDataLabels | 505 |
| xlDialogChartOptionsDataTable | 506 |
| xlDialogChartSourceData | 540 |
| xlDialogChartTrend | 350 |
| xlDialogChartType | 526 |
| xlDialogChartWizard | 288 |
| xlDialogCheckboxProperties | 435 |
| xlDialogClear | 52 |
| xlDialogColorPalette | 161 |
| xlDialogColumnWidth | 47 |
| xlDialogCombination | 73 |
| xlDialogConditionalFormatting | 583 |
| xlDialogConsolidate | 191 |
| xlDialogCopyChart | 147 |
| xlDialogCopyPicture | 108 |
| xlDialogCreateList | 796 |
| xlDialogCreateNames | 62 |
| xlDialogCreatePublisher | 217 |
| xlDialogCreateRelationship | (Added in 2013) |
| xlDialogCustomizeToolbar | 276 |
| xlDialogCustomViews | 493 |
| xlDialogDataDelete | 36 |
| xlDialogDataLabel | 379 |
| xlDialogDataLabelMultiple | 723 |
| xlDialogDataSeries | 40 |
| xlDialogDataValidation | 525 |
| xlDialogDefineName | 61 |
| xlDialogDefineStyle | 229 |
| xlDialogDeleteFormat | 111 |
| xlDialogDeleteName | 110 |
| xlDialogDemote | 203 |
| xlDialogDisplay | 27 |
| xlDialogDocumentInspector | (Added in 2007) |
| xlDialogEditboxProperties | 438 |
| xlDialogEditColor | 223 |
| xlDialogEditDelete | 54 |
| xlDialogEditionOptions | 251 |
| xlDialogEditSeries | 228 |
| xlDialogErrorbarX | 463 |
| xlDialogErrorbarY | 464 |
| xlDialogErrorChecking | 732 |
| xlDialogEvaluateFormula | 709 |
| xlDialogExternalDataProperties | 530 |
| xlDialogExtract | 35 |
| xlDialogFileDelete | 6 |
| xlDialogFileSharing | 481 |
| xlDialogFillGroup | 200 |
| xlDialogFillWorkgroup | 301 |
| xlDialogFilter | 447 |
| xlDialogFilterAdvanced | 370 |
| xlDialogFindFile | 475 |
| xlDialogFont | 26 |
| xlDialogFontProperties | 381 |
| xlDialogFormatAuto | 269 |
| xlDialogFormatChart | 465 |
| xlDialogFormatCharttype | 423 |
| xlDialogFormatFont | 150 |
| xlDialogFormatLegend | 88 |
| xlDialogFormatMain | 225 |
| xlDialogFormatMove | 128 |
| xlDialogFormatNumber | 42 |
| xlDialogFormatOverlay | 226 |
| xlDialogFormatSize | 129 |
| xlDialogFormatText | 89 |
| xlDialogFormulaFind | 64 |
| xlDialogFormulaGoto | 63 |
| xlDialogFormulaReplace | 130 |
| xlDialogFunctionWizard | 450 |
| xlDialogGallery3dArea | 193 |
| xlDialogGallery3dBar | 272 |
| xlDialogGallery3dColumn | 194 |
| xlDialogGallery3dLine | 195 |
| xlDialogGallery3dPie | 196 |
| xlDialogGallery3dSurface | 273 |
| xlDialogGalleryArea | 67 |
| xlDialogGalleryBar | 68 |
| xlDialogGalleryColumn | 69 |
| xlDialogGalleryCustom | 388 |
| xlDialogGalleryDoughnut | 344 |
| xlDialogGalleryLine | 70 |
| xlDialogGalleryPie | 71 |
| xlDialogGalleryRadar | 249 |
| xlDialogGalleryScatter | 72 |
| xlDialogGoalSeek | 198 |
| xlDialogGridlines | 76 |
| xlDialogImportTextFile | 666 |
| xlDialogInsert | 55 |
| xlDialogInsertHyperlink | 596 |
| xlDialogInsertNameLabel | 496 |
| xlDialogInsertObject | 259 |
| xlDialogInsertPicture | 342 |
| xlDialogInsertTitle | 380 |
| xlDialogLabelProperties | 436 |
| xlDialogListboxProperties | 437 |
| xlDialogMacroOptions | 382 |
| xlDialogMailEditMailer | 470 |
| xlDialogMailLogon | 339 |
| xlDialogMailNextLetter | 378 |
| xlDialogMainChart | 85 |
| xlDialogMainChartType | 185 |
| xlDialogManageRelationships | (Added in 2013) |
| xlDialogMenuEditor | 322 |
| xlDialogMove | 262 |
| xlDialogMyPermission | 834 |
| xlDialogNameManager | (Added in 2007) |
| xlDialogNew | 119 |
| xlDialogNewName | (Added in 2007) |
| xlDialogNewWebQuery | 667 |
| xlDialogNote | 154 |
| xlDialogObjectProperties | 207 |
| xlDialogObjectProtection | 214 |
| xlDialogOpen | 1 |
| xlDialogOpenLinks | 2 |
| xlDialogOpenMail | 188 |
| xlDialogOpenText | 441 |
| xlDialogOptionsCalculation | 318 |
| xlDialogOptionsChart | 325 |
| xlDialogOptionsEdit | 319 |
| xlDialogOptionsGeneral | 356 |
| xlDialogOptionsListsAdd | 458 |
| xlDialogOptionsME | 647 |
| xlDialogOptionsTransition | 355 |
| xlDialogOptionsView | 320 |
| xlDialogOutline | 142 |
| xlDialogOverlay | 86 |
| xlDialogOverlayChartType | 186 |
| xlDialogPageSetup | 7 |
| xlDialogParse | 91 |
| xlDialogPasteNames | 58 |
| xlDialogPasteSpecial | 53 |
| xlDialogPatterns | 84 |
| xlDialogPermission | 832 |
| xlDialogPhonetic | 656 |
| xlDialogPivotCalculatedField | 570 |
| xlDialogPivotCalculatedItem | 572 |
| xlDialogPivotClientServerSet | 689 |
| xlDialogPivotFieldGroup | 433 |
| xlDialogPivotFieldProperties | 313 |
| xlDialogPivotFieldUngroup | 434 |
| xlDialogPivotShowPages | 421 |
| xlDialogPivotSolveOrder | 568 |
| xlDialogPivotTableOptions | 567 |
| xlDialogPivotTableSlicerConnections | (Added in 2010) |
| xlDialogPivotTableWhatIfAnalysisSettings | (Added in 2010) |
| xlDialogPivotTableWizard | 312 |
| xlDialogPlacement | 300 |
| xlDialogPrint | 8 |
| xlDialogPrinterSetup | 9 |
| xlDialogPrintPreview | 222 |
| xlDialogPromote | 202 |
| xlDialogProperties | 474 |
| xlDialogPropertyFields | 754 |
| xlDialogProtectDocument | 28 |
| xlDialogProtectSharing | 620 |
| xlDialogPublishAsWebPage | 653 |
| xlDialogPushbuttonProperties | 445 |
| xlDialogRecommendPivotTables | (Added in 2013) |
| xlDialogReplaceFont | 134 |
| xlDialogRoutingSlip | 336 |
| xlDialogRowHeight | 127 |
| xlDialogRun | 17 |
| xlDialogSaveAs | 5 |
| xlDialogSaveCopyAs | 456 |
| xlDialogSaveNewObject | 208 |
| xlDialogSaveWorkbook | 145 |
| xlDialogSaveWorkspace | 285 |
| xlDialogScale | 87 |
| xlDialogScenarioAdd | 307 |
| xlDialogScenarioCells | 305 |
| xlDialogScenarioEdit | 308 |
| xlDialogScenarioMerge | 473 |
| xlDialogScenarioSummary | 311 |
| xlDialogScrollbarProperties | 420 |
| xlDialogSearch | 731 |
| xlDialogSelectSpecial | 132 |
| xlDialogSendMail | 189 |
| xlDialogSeriesAxes | 460 |
| xlDialogSeriesOptions | 557 |
| xlDialogSeriesOrder | 466 |
| xlDialogSeriesShape | 504 |
| xlDialogSeriesX | 461 |
| xlDialogSeriesY | 462 |
| xlDialogSetBackgroundPicture | 509 |
| xlDialogSetManager | (Added in 2010) |
| xlDialogSetMDXEditor | (Added in 2010) |
| xlDialogSetPrintTitles | 23 |
| xlDialogSetTupleEditorOnColumns | (Added in 2010) |
| xlDialogSetTupleEditorOnRows | (Added in 2010) |
| xlDialogSetUpdateStatus | 159 |
| xlDialogShowDetail | 204 |
| xlDialogShowToolbar | 220 |
| xlDialogSize | 261 |
| xlDialogSlicerCreation | (Added in 2010) |
| xlDialogSlicerPivotTableConnections | (Added in 2010) |
| xlDialogSlicerSettings | (Added in 2010) |
| xlDialogSort | 39 |
| xlDialogSortSpecial | 192 |
| xlDialogSparklineInsertColumn | (Added in 2010) |
| xlDialogSparklineInsertLine | (Added in 2010) |
| xlDialogSparklineInsertWinLoss | (Added in 2010) |
| xlDialogSplit | 137 |
| xlDialogStandardFont | 190 |
| xlDialogStandardWidth | 472 |
| xlDialogStyle | 44 |
| xlDialogSubscribeTo | 218 |
| xlDialogSubtotalCreate | 398 |
| xlDialogSummaryInfo | 474 |
| xlDialogTable | 41 |
| xlDialogTabOrder | 394 |
| xlDialogTextToColumns | 422 |
| xlDialogUnhide | 94 |
| xlDialogUpdateLink | 201 |
| xlDialogVbaInsertFile | 328 |
| xlDialogVbaMakeAddin | 478 |
| xlDialogVbaProcedureDefinition | 330 |
| xlDialogView3d | 197 |
| xlDialogWebOptionsBrowsers | 773 |
| xlDialogWebOptionsEncoding | 686 |
| xlDialogWebOptionsFiles | 684 |
| xlDialogWebOptionsFonts | 687 |
| xlDialogWebOptionsGeneral | 683 |
| xlDialogWebOptionsPictures | 685 |
| xlDialogWindowMove | 14 |
| xlDialogWindowSize | 13 |
| xlDialogWorkbookAdd | 281 |
| xlDialogWorkbookCopy | 283 |
| xlDialogWorkbookInsert | 354 |
| xlDialogWorkbookMove | 282 |
| xlDialogWorkbookName | 386 |
| xlDialogWorkbookNew | 302 |
| xlDialogWorkbookOptions | 284 |
| xlDialogWorkbookProtect | 417 |
| xlDialogWorkbookTabSplit | 415 |
| xlDialogWorkbookUnhide | 384 |
| xlDialogWorkgroup | 199 |
| xlDialogWorkspace | 95 |
| xlDialogZoom | 256 |
| xlDialogActivate |
| 103 |
| xlDialogActiveCellFont |
| 476 |
| xlDialogAddChartAutoformat |
| 390 |
| xlDialogAddinManager |
| 321 |
| xlDialogAlignment |
| 43 |
| xlDialogApplyNames |
| 133 |
| xlDialogApplyStyle |
| 212 |
| xlDialogAppMove |
| 170 |
| xlDialogAppSize |
| 171 |
| xlDialogArrangeAll |
| 12 |
| xlDialogAssignToObject |
| 213 |
| xlDialogAssignToTool |
| 293 |
| xlDialogAttachText |
| 80 |
| xlDialogAttachToolbars |
| 323 |
| xlDialogAutoCorrect |
| 485 |
| xlDialogAxes |
| 78 |
| xlDialogBorder |
| 45 |
| xlDialogCalculation |
| 32 |
| xlDialogCellProtection |
| 46 |
| xlDialogChangeLink |
| 166 |
| xlDialogChartAddData |
| 392 |
| xlDialogChartLocation |
| 527 |
| xlDialogChartOptionsDataLabelMultiple |
| 724 |
| xlDialogChartOptionsDataLabels |
| 505 |
| xlDialogChartOptionsDataTable |
| 506 |
| xlDialogChartSourceData |
| 540 |
| xlDialogChartTrend |
| 350 |
| xlDialogChartType |
| 526 |
| xlDialogChartWizard |
| 288 |
| xlDialogCheckboxProperties |
| 435 |
| xlDialogClear |
| 52 |
| xlDialogColorPalette |
| 161 |
| xlDialogColumnWidth |
| 47 |
| xlDialogCombination |
| 73 |
| xlDialogConditionalFormatting |
| 583 |
| xlDialogConsolidate |
| 191 |
| xlDialogCopyChart |
| 147 |
| xlDialogCopyPicture |
| 108 |
| xlDialogCreateList |
| 796 |
| xlDialogCreateNames |
| 62 |
| xlDialogCreatePublisher |
| 217 |
| xlDialogCreateRelationship |
| (Added in 2013) |
| xlDialogCustomizeToolbar |
| 276 |
| xlDialogCustomViews |
| 493 |
| xlDialogDataDelete |
| 36 |
| xlDialogDataLabel |
| 379 |
| xlDialogDataLabelMultiple |
| 723 |
| xlDialogDataSeries |
| 40 |
| xlDialogDataValidation |
| 525 |
| xlDialogDefineName |
| 61 |
| xlDialogDefineStyle |
| 229 |
| xlDialogDeleteFormat |
| 111 |
| xlDialogDeleteName |
| 110 |
| xlDialogDemote |
| 203 |
| xlDialogDisplay |
| 27 |
| xlDialogDocumentInspector |
| (Added in 2007) |
| xlDialogEditboxProperties |
| 438 |
| xlDialogEditColor |
| 223 |
| xlDialogEditDelete |
| 54 |
| xlDialogEditionOptions |
| 251 |
| xlDialogEditSeries |
| 228 |
| xlDialogErrorbarX |
| 463 |
| xlDialogErrorbarY |
| 464 |
| xlDialogErrorChecking |
| 732 |
| xlDialogEvaluateFormula |
| 709 |
| xlDialogExternalDataProperties |
| 530 |
| xlDialogExtract |
| 35 |
| xlDialogFileDelete |
| 6 |
| xlDialogFileSharing |
| 481 |
| xlDialogFillGroup |
| 200 |
| xlDialogFillWorkgroup |
| 301 |
| xlDialogFilter |
| 447 |
| xlDialogFilterAdvanced |
| 370 |
| xlDialogFindFile |
| 475 |
| xlDialogFont |
| 26 |
| xlDialogFontProperties |
| 381 |
| xlDialogFormatAuto |
| 269 |
| xlDialogFormatChart |
| 465 |
| xlDialogFormatCharttype |
| 423 |
| xlDialogFormatFont |
| 150 |
| xlDialogFormatLegend |
| 88 |
| xlDialogFormatMain |
| 225 |
| xlDialogFormatMove |
| 128 |
| xlDialogFormatNumber |
| 42 |
| xlDialogFormatOverlay |
| 226 |
| xlDialogFormatSize |
| 129 |
| xlDialogFormatText |
| 89 |
| xlDialogFormulaFind |
| 64 |
| xlDialogFormulaGoto |
| 63 |
| xlDialogFormulaReplace |
| 130 |
| xlDialogFunctionWizard |
| 450 |
| xlDialogGallery3dArea |
| 193 |
| xlDialogGallery3dBar |
| 272 |
| xlDialogGallery3dColumn |
| 194 |
| xlDialogGallery3dLine |
| 195 |
| xlDialogGallery3dPie |
| 196 |
| xlDialogGallery3dSurface |
| 273 |
| xlDialogGalleryArea |
| 67 |
| xlDialogGalleryBar |
| 68 |
| xlDialogGalleryColumn |
| 69 |
| xlDialogGalleryCustom |
| 388 |
| xlDialogGalleryDoughnut |
| 344 |
| xlDialogGalleryLine |
| 70 |
| xlDialogGalleryPie |
| 71 |
| xlDialogGalleryRadar |
| 249 |
| xlDialogGalleryScatter |
| 72 |
| xlDialogGoalSeek |
| 198 |
| xlDialogGridlines |
| 76 |
| xlDialogImportTextFile |
| 666 |
| xlDialogInsert |
| 55 |
| xlDialogInsertHyperlink |
| 596 |
| xlDialogInsertNameLabel |
| 496 |
| xlDialogInsertObject |
| 259 |
| xlDialogInsertPicture |
| 342 |
| xlDialogInsertTitle |
| 380 |
| xlDialogLabelProperties |
| 436 |
| xlDialogListboxProperties |
| 437 |
| xlDialogMacroOptions |
| 382 |
| xlDialogMailEditMailer |
| 470 |
| xlDialogMailLogon |
| 339 |
| xlDialogMailNextLetter |
| 378 |
| xlDialogMainChart |
| 85 |
| xlDialogMainChartType |
| 185 |
| xlDialogManageRelationships |
| (Added in 2013) |
| xlDialogMenuEditor |
| 322 |
| xlDialogMove |
| 262 |
| xlDialogMyPermission |
| 834 |
| xlDialogNameManager |
| (Added in 2007) |
| xlDialogNew |
| 119 |
| xlDialogNewName |
| (Added in 2007) |
| xlDialogNewWebQuery |
| 667 |
| xlDialogNote |
| 154 |
| xlDialogObjectProperties |
| 207 |
| xlDialogObjectProtection |
| 214 |
| xlDialogOpen |
| 1 |
| xlDialogOpenLinks |
| 2 |
| xlDialogOpenMail |
| 188 |
| xlDialogOpenText |
| 441 |
| xlDialogOptionsCalculation |
| 318 |
| xlDialogOptionsChart |
| 325 |
| xlDialogOptionsEdit |
| 319 |
| xlDialogOptionsGeneral |
| 356 |
| xlDialogOptionsListsAdd |
| 458 |
| xlDialogOptionsME |
| 647 |
| xlDialogOptionsTransition |
| 355 |
| xlDialogOptionsView |
| 320 |
| xlDialogOutline |
| 142 |
| xlDialogOverlay |
| 86 |
| xlDialogOverlayChartType |
| 186 |
| xlDialogPageSetup |
| 7 |
| xlDialogParse |
| 91 |
| xlDialogPasteNames |
| 58 |
| xlDialogPasteSpecial |
| 53 |
| xlDialogPatterns |
| 84 |
| xlDialogPermission |
| 832 |
| xlDialogPhonetic |
| 656 |
| xlDialogPivotCalculatedField |
| 570 |
| xlDialogPivotCalculatedItem |
| 572 |
| xlDialogPivotClientServerSet |
| 689 |
| xlDialogPivotFieldGroup |
| 433 |
| xlDialogPivotFieldProperties |
| 313 |
| xlDialogPivotFieldUngroup |
| 434 |
| xlDialogPivotShowPages |
| 421 |
| xlDialogPivotSolveOrder |
| 568 |
| xlDialogPivotTableOptions |
| 567 |
| xlDialogPivotTableSlicerConnections |
| (Added in 2010) |
| xlDialogPivotTableWhatIfAnalysisSettings |
| (Added in 2010) |
| xlDialogPivotTableWizard |
| 312 |
| xlDialogPlacement |
| 300 |
| xlDialogPrint |
| 8 |
| xlDialogPrinterSetup |
| 9 |
| xlDialogPrintPreview |
| 222 |
| xlDialogPromote |
| 202 |
| xlDialogProperties |
| 474 |
| xlDialogPropertyFields |
| 754 |
| xlDialogProtectDocument |
| 28 |
| xlDialogProtectSharing |
| 620 |
| xlDialogPublishAsWebPage |
| 653 |
| xlDialogPushbuttonProperties |
| 445 |
| xlDialogRecommendPivotTables |
| (Added in 2013) |
| xlDialogReplaceFont |
| 134 |
| xlDialogRoutingSlip |
| 336 |
| xlDialogRowHeight |
| 127 |
| xlDialogRun |
| 17 |
| xlDialogSaveAs |
| 5 |
| xlDialogSaveCopyAs |
| 456 |
| xlDialogSaveNewObject |
| 208 |
| xlDialogSaveWorkbook |
| 145 |
| xlDialogSaveWorkspace |
| 285 |
| xlDialogScale |
| 87 |
| xlDialogScenarioAdd |
| 307 |
| xlDialogScenarioCells |
| 305 |
| xlDialogScenarioEdit |
| 308 |
| xlDialogScenarioMerge |
| 473 |
| xlDialogScenarioSummary |
| 311 |
| xlDialogScrollbarProperties |
| 420 |
| xlDialogSearch |
| 731 |
| xlDialogSelectSpecial |
| 132 |
| xlDialogSendMail |
| 189 |
| xlDialogSeriesAxes |
| 460 |
| xlDialogSeriesOptions |
| 557 |
| xlDialogSeriesOrder |
| 466 |
| xlDialogSeriesShape |
| 504 |
| xlDialogSeriesX |
| 461 |
| xlDialogSeriesY |
| 462 |
| xlDialogSetBackgroundPicture |
| 509 |
| xlDialogSetManager |
| (Added in 2010) |
| xlDialogSetMDXEditor |
| (Added in 2010) |
| xlDialogSetPrintTitles |
| 23 |
| xlDialogSetTupleEditorOnColumns |
| (Added in 2010) |
| xlDialogSetTupleEditorOnRows |
| (Added in 2010) |
| xlDialogSetUpdateStatus |
| 159 |
| xlDialogShowDetail |
| 204 |
| xlDialogShowToolbar |
| 220 |
| xlDialogSize |
| 261 |
| xlDialogSlicerCreation |
| (Added in 2010) |
| xlDialogSlicerPivotTableConnections |
| (Added in 2010) |
| xlDialogSlicerSettings |
| (Added in 2010) |
| xlDialogSort |
| 39 |
| xlDialogSortSpecial |
| 192 |
| xlDialogSparklineInsertColumn |
| (Added in 2010) |
| xlDialogSparklineInsertLine |
| (Added in 2010) |
| xlDialogSparklineInsertWinLoss |
| (Added in 2010) |
| xlDialogSplit |
| 137 |
| xlDialogStandardFont |
| 190 |
| xlDialogStandardWidth |
| 472 |
| xlDialogStyle |
| 44 |
| xlDialogSubscribeTo |
| 218 |
| xlDialogSubtotalCreate |
| 398 |
| xlDialogSummaryInfo |
| 474 |
| xlDialogTable |
| 41 |
| xlDialogTabOrder |
| 394 |
| xlDialogTextToColumns |
| 422 |
| xlDialogUnhide |
| 94 |
| xlDialogUpdateLink |
| 201 |
| xlDialogVbaInsertFile |
| 328 |
| xlDialogVbaMakeAddin |
| 478 |
| xlDialogVbaProcedureDefinition |
| 330 |
| xlDialogView3d |
| 197 |
| xlDialogWebOptionsBrowsers |
| 773 |
| xlDialogWebOptionsEncoding |
| 686 |
| xlDialogWebOptionsFiles |
| 684 |
| xlDialogWebOptionsFonts |
| 687 |
| xlDialogWebOptionsGeneral |
| 683 |
| xlDialogWebOptionsPictures |
| 685 |
| xlDialogWindowMove |
| 14 |
| xlDialogWindowSize |
| 13 |
| xlDialogWorkbookAdd |
| 281 |
| xlDialogWorkbookCopy |
| 283 |
| xlDialogWorkbookInsert |
| 354 |
| xlDialogWorkbookMove |
| 282 |
| xlDialogWorkbookName |
| 386 |
| xlDialogWorkbookNew |
| 302 |
| xlDialogWorkbookOptions |
| 284 |
| xlDialogWorkbookProtect |
| 417 |
| xlDialogWorkbookTabSplit |
| 415 |
| xlDialogWorkbookUnhide |
| 384 |
| xlDialogWorkgroup |
| 199 |
| xlDialogWorkspace |
| 95 |
| xlDialogZoom |
| 256 |
xlCalcFor |
| Specifies what should be calculated. |
| xlAllValues | All values (0) |
| xlColGroups | Column groups (2) |
| xlRowGroups | Row groups (1) |
| xlAllValues |
| All values (0) |
| xlColGroups |
| Column groups (2) |
| xlRowGroups |
| Row groups (1) |
| REMARKS |
| * Added in 2007. |
xlCalcMemNumberFormatType |
| Specifies the format of cell values that are based on the calculated member. |
| xlNumberFormatTypeDefault | Use the default format type of the calculated member for the cell value (0) |
| xlNumberFormatTypeNumber | The calculated member format is a number (1) |
| xlNumberFormatTypePercent | The calculated member format is a percentage (2) |
| xlNumberFormatTypeDefault |
| Use the default format type of the calculated member for the cell value (0) |
| xlNumberFormatTypeNumber |
| The calculated member format is a number (1) |
| xlNumberFormatTypePercent |
| The calculated member format is a percentage (2) |
| REMARKS |
| * Added in 2013. |
xlCategoryLabelLevel |
| Specifies the category labels for the category label levels. |
| xlCategoryLabelLevelAll | (default) Set category labels to all category label levels within range on the chart (-1) |
| xlCategoryLabelLevelCustom | Indicates literal data in the category labels (-2) |
| xlCategoryLabelLevelNone | Set no category labels in the chart and use automatic indexed labels (-3) |
| xlCategoryLabelLevelAll |
| (default) Set category labels to all category label levels within range on the chart (-1) |
| xlCategoryLabelLevelCustom |
| Indicates literal data in the category labels (-2) |
| xlCategoryLabelLevelNone |
| Set no category labels in the chart and use automatic indexed labels (-3) |
| REMARKS |
| * Added in 2013. |
xlCategorySortOrder |
| Specifies the sort order for the category. |
| xlCategoryAscending | Ascending Category (2) |
| xlCategoryDescending | Descending Category (3) |
| xlIndexAscending | Ascending Index (0) |
| xlIndexDescending | Descending Index (1) |
| xlCategoryAscending |
| Ascending Category (2) |
| xlCategoryDescending |
| Descending Category (3) |
| xlIndexAscending |
| Ascending Index (0) |
| xlIndexDescending |
| Descending Index (1) |
| REMARKS |
| * Added in 2019. |
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. |
| xlInsertDeleteCells | Partial rows are inserted or deleted to match the exact number of rows required for the new recordset (1) |
| xlInsertEntireRows | Entire rows are inserted, if necessary, to accommodate any overflow No cells or rows are deleted from the worksheet (2) |
| xlOverwriteCells | No new cells or rows are added to the worksheet Data in surrounding cells is overwritten to accommodate any overflow (0) |
| xlInsertDeleteCells |
| Partial rows are inserted or deleted to match the exact number of rows required for the new recordset (1) |
| xlInsertEntireRows |
| Entire rows are inserted, if necessary, to accommodate any overflow No cells or rows are deleted from the worksheet (2) |
| xlOverwriteCells |
| No new cells or rows are added to the worksheet Data in surrounding cells is overwritten to accommodate any overflow (0) |
xlCellType |
| Specifies the type of cells. |
| xlCellTypeAllFormatConditions | Any type of Cells (-4172) |
| xlCellTypeAllValidation | Cells with Validation Criteria (-4174) |
| xlCellTypeBlanks | Blank Cells (4) |
| xlCellTypeComments | Cells with Comments (-4144) |
| xlCellTypeConstants | Cells with Constants (Non-Formula & Non-Blank) (2) |
| xlCellTypeFormulas | Cells with Formulas (beginning with a =) (-4123) |
| xlCellTypeLastCell | Get Last Cell in the UsedRange (11) |
| xlCellTypeSameFormatConditions | Cells with Common Format Conditions (-4173) |
| xlCellTypeSameValidation | Cells with Common Validation Criteria (-4175) |
| xlCellTypeVisible | All Visible Cells (12) |
| xlCellTypeAllFormatConditions |
| Any type of Cells (-4172) |
| xlCellTypeAllValidation |
| Cells with Validation Criteria (-4174) |
| xlCellTypeBlanks |
| Blank Cells (4) |
| xlCellTypeComments |
| Cells with Comments (-4144) |
| xlCellTypeConstants |
| Cells with Constants (Non-Formula & Non-Blank) (2) |
| xlCellTypeFormulas |
| Cells with Formulas (beginning with a =) (-4123) |
| xlCellTypeLastCell |
| Get Last Cell in the UsedRange (11) |
| xlCellTypeSameFormatConditions |
| Cells with Common Format Conditions (-4173) |
| xlCellTypeSameValidation |
| Cells with Common Validation Criteria (-4175) |
| xlCellTypeVisible |
| All Visible Cells (12) |
xlChartElementPosition |
| Specifies the position of the chart element. |
| xlChartElementPositionAutomatic | Automatically sets the position of the chart element (-4105) |
| xlChartElementPositionCustom | Specifies a specific position for the chart element (-4114) |
| xlChartElementPositionAutomatic |
| Automatically sets the position of the chart element (-4105) |
| xlChartElementPositionCustom |
| Specifies a specific position for the chart element (-4114) |
| REMARKS |
| * Added in 2007. |
xlClipboardFormat |
| Specifies the format of an item on the Windows clipboard. |
| xlClipboardFormatBIFF | BIFF (8) |
| xlClipboardFormatBIFF2 | BIFF2 (18) |
| xlClipboardFormatBIFF3 | BIFF3 (20) |
| xlClipboardFormatBIFF4 | BIFF4 (30) |
| xlClipboardFormatBIFF12 | (Added in 2007) BIFF12 (63) |
| xlClipboardFormatBinary | Binary (15) |
| xlClipboardFormatBitmap | Bitmap (9) |
| xlClipboardFormatCGM | CGM (13) |
| xlClipboardFormatCSV | CSV (5) |
| xlClipboardFormatDIF | DIF (4) |
| xlClipboardFormatDspText | Dsp Text (12) |
| xlClipboardFormatEmbeddedObject | Embedded Object (21) |
| xlClipboardFormatEmbedSource | Embed Source (22) |
| xlClipboardFormatLink | Link (11) |
| xlClipboardFormatLinkSource | Link Source (23) |
| xlClipboardFormatLinkSourceDesc | Link Source Desc (32) |
| xlClipboardFormatMovie | Movie (24) |
| xlClipboardFormatNative | Native (14) |
| xlClipboardFormatObjectDesc | Object Desc (31) |
| xlClipboardFormatObjectLink | Object Link (19) |
| xlClipboardFormatOwnerLink | Owner Link (17) |
| xlClipboardFormatPICT | PICT (2) |
| xlClipboardFormatPrintPICT | Print PICT (3) |
| xlClipboardFormatRTF | RTF (7) |
| xlClipboardFormatScreenPICT | Screen PICT (29) |
| xlClipboardFormatStandardFont | Standard Font (28) |
| xlClipboardFormatStandardScale | Standard Scale (27) |
| xlClipboardFormatSYLK | SYLK (6) |
| xlClipboardFormatTable | Table (16) |
| xlClipboardFormatText | Text (0) |
| xlClipboardFormatToolFace | Tool Face (25) |
| xlClipboardFormatToolFacePICT | Tool Face PICT (26) |
| xlClipboardFormatVALU | VALU (1) |
| xlClipboardFormatWK1 | WK1 (10) |
| xlClipboardFormatBIFF |
| BIFF (8) |
| xlClipboardFormatBIFF2 |
| BIFF2 (18) |
| xlClipboardFormatBIFF3 |
| BIFF3 (20) |
| xlClipboardFormatBIFF4 |
| BIFF4 (30) |
| xlClipboardFormatBIFF12 |
| (Added in 2007) BIFF12 (63) |
| xlClipboardFormatBinary |
| Binary (15) |
| xlClipboardFormatBitmap |
| Bitmap (9) |
| xlClipboardFormatCGM |
| CGM (13) |
| xlClipboardFormatCSV |
| CSV (5) |
| xlClipboardFormatDIF |
| DIF (4) |
| xlClipboardFormatDspText |
| Dsp Text (12) |
| xlClipboardFormatEmbeddedObject |
| Embedded Object (21) |
| xlClipboardFormatEmbedSource |
| Embed Source (22) |
| xlClipboardFormatLink |
| Link (11) |
| xlClipboardFormatLinkSource |
| Link Source (23) |
| xlClipboardFormatLinkSourceDesc |
| Link Source Desc (32) |
| xlClipboardFormatMovie |
| Movie (24) |
| xlClipboardFormatNative |
| Native (14) |
| xlClipboardFormatObjectDesc |
| Object Desc (31) |
| xlClipboardFormatObjectLink |
| Object Link (19) |
| xlClipboardFormatOwnerLink |
| Owner Link (17) |
| xlClipboardFormatPICT |
| PICT (2) |
| xlClipboardFormatPrintPICT |
| Print PICT (3) |
| xlClipboardFormatRTF |
| RTF (7) |
| xlClipboardFormatScreenPICT |
| Screen PICT (29) |
| xlClipboardFormatStandardFont |
| Standard Font (28) |
| xlClipboardFormatStandardScale |
| Standard Scale (27) |
| xlClipboardFormatSYLK |
| SYLK (6) |
| xlClipboardFormatTable |
| Table (16) |
| xlClipboardFormatText |
| Text (0) |
| xlClipboardFormatToolFace |
| Tool Face (25) |
| xlClipboardFormatToolFacePICT |
| Tool Face PICT (26) |
| xlClipboardFormatVALU |
| VALU (1) |
| xlClipboardFormatWK1 |
| WK1 (10) |
xlCmdType |
| Specifies the value of the commandtext property. |
| xlCmdCube | Cube (1) |
| xlCmdDAX | (Added in 2013) DAX (8) |
| xlCmdDefault | Default (4) |
| xlCmdExcel | (Added in 2013) Excel (7) |
| xlCmdList | List (5) |
| xlCmdSql | SQL (2) |
| xlCmdTable | Table (3) |
| xlCmdTableCollection | (Added in 2013) Table Collection (6) |
| xlCmdCube |
| Cube (1) |
| xlCmdDAX |
| (Added in 2013) DAX (8) |
| xlCmdDefault |
| Default (4) |
| xlCmdExcel |
| (Added in 2013) Excel (7) |
| xlCmdList |
| List (5) |
| xlCmdSql |
| SQL (2) |
| xlCmdTable |
| Table (3) |
| xlCmdTableCollection |
| (Added in 2013) Table Collection (6) |
| REMARKS |
| * Added in 2000. |
xlColumnDataType |
| Specifies how a column is to be parsed. |
| xlDMYFormat | DMY date format (4) |
| xlDYMFormat | DYM date format (7) |
| xlEMDFormat | EMD date format (10) |
| xlGeneralFormat | General (1) |
| xlMDYFormat | MDY date format (3) |
| xlMYDFormat | MYD date format (6) |
| xlSkipColumn | Column is not parsed (9) |
| xlTextFormat | Text (2) |
| xlYDMFormat | YDM date format (8) |
| xlYMDFormat | YMD date format (5) |
| xlDMYFormat |
| DMY date format (4) |
| xlDYMFormat |
| DYM date format (7) |
| xlEMDFormat |
| EMD date format (10) |
| xlGeneralFormat |
| General (1) |
| xlMDYFormat |
| MDY date format (3) |
| xlMYDFormat |
| MYD date format (6) |
| xlSkipColumn |
| Column is not parsed (9) |
| xlTextFormat |
| Text (2) |
| xlYDMFormat |
| YDM date format (8) |
| xlYMDFormat |
| YMD date format (5) |
| REMARKS |
| * Added in 2000. * You can use xlEMDFormat only if Taiwanese language support is installed and selected. The xlEMDFormat constant specifies that Taiwanese era dates are being used. |
xlCommandUnderlines |
| Specifies the state of the command underlines in Excel for the Macintosh. |
| xlCommandUnderlinesAutomatic | Excel controls the display of command underlines (-410)5 |
| xlCommandUnderlinesOff | Command underlines are not displayed (-4146) |
| xlCommandUnderlinesOn | Command underlines are displayed (1) |
| xlCommandUnderlinesAutomatic |
| Excel controls the display of command underlines (-410)5 |
| xlCommandUnderlinesOff |
| Command underlines are not displayed (-4146) |
| xlCommandUnderlinesOn |
| Command underlines are displayed (1) |
xlCommentDisplayMode |
| Specifies the way cells display comments and comment indicators. |
| xlCommentAndIndicator | Displays comment and indicator at all times (1) |
| xlCommentIndicatorOnly | Displays comment indicator only and only shows the comment when the mouse pointer is over the cell (-1) |
| xlNoIndicator | No indication The comment nor the indicator is displayed at any time (0) |
| xlCommentAndIndicator |
| Displays comment and indicator at all times (1) |
| xlCommentIndicatorOnly |
| Displays comment indicator only and only shows the comment when the mouse pointer is over the cell (-1) |
| xlNoIndicator |
| No indication The comment nor the indicator is displayed at any time (0) |
xlConnectionType |
| Specifies the type of database connection. |
| xlConnectionTypeDATAFEED | (Added in 2013) Data Feed (6) |
| xlConnectionTypeMODEL | (Added in 2013) Model (7) |
| xlConnectionTypeNOSOURCE | (Added in 2013) No Source (9) |
| xlConnectionTypeODBC | ODBC (2) |
| xlConnectionTypeOLEDB | OLEDB (1) |
| xlConnectionTypeTEXT | Text (4) |
| xlConnectionTypeWEB | Web (5) |
| xlConnectionTypeWORKSHEET | (Added in 2013) Worksheet (8) |
| xlConnectionTypeXMLMAP | XML MAP (3) |
| xlConnectionTypeDATAFEED |
| (Added in 2013) Data Feed (6) |
| xlConnectionTypeMODEL |
| (Added in 2013) Model (7) |
| xlConnectionTypeNOSOURCE |
| (Added in 2013) No Source (9) |
| xlConnectionTypeODBC |
| ODBC (2) |
| xlConnectionTypeOLEDB |
| OLEDB (1) |
| xlConnectionTypeTEXT |
| Text (4) |
| xlConnectionTypeWEB |
| Web (5) |
| xlConnectionTypeWORKSHEET |
| (Added in 2013) Worksheet (8) |
| xlConnectionTypeXMLMAP |
| XML MAP (3) |
| REMARKS |
| * Added in 2007. |
xlContainsOperator |
| Specifies the operator used in a function. |
| xlBeginsWith | Begins with a specified value (2) |
| xlContains | Contains a specified value (0) |
| xlDoesNotContain | Does not contain the specified value (1) |
| xlEndsWith | Ends with the specified value (3) |
| xlBeginsWith |
| Begins with a specified value (2) |
| xlContains |
| Contains a specified value (0) |
| xlDoesNotContain |
| Does not contain the specified value (1) |
| xlEndsWith |
| Ends with the specified value (3) |
| REMARKS |
| * Added in 2007. |
xlCopyPictureFormat |
| Specifies the format of the picture being copied. |
| xlBitmap | Picture copied in bitmap (raster) format: bmp, jpg, gif, png (2) |
| xlPicture | Picture copied in vector format: emf, wmf (-4147) |
| xlBitmap |
| Picture copied in bitmap (raster) format: bmp, jpg, gif, png (2) |
| xlPicture |
| Picture copied in vector format: emf, wmf (-4147) |
xlCorruptLoad |
| Specifies the processing for a file when it is opened. |
| xlExtractData | Workbook is opened in extract data mode (2) |
| xlNormalLoad | Workbook is opened normally (0) |
| xlRepairFile | Workbook is opened in repair mode (1) |
| xlExtractData |
| Workbook is opened in extract data mode (2) |
| xlNormalLoad |
| Workbook is opened normally (0) |
| xlRepairFile |
| Workbook is opened in repair mode (1) |
| REMARKS |
| * Added in 2002. |
xlCreator |
| Specifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL). |
| xlCreatorCode | The Excel for Macintosh creator code (1480803660) |
| xlCreatorCode |
| The Excel for Macintosh creator code (1480803660) |
xlCredentialsMethod |
| Specifies the type of credentials method used. |
| CredentialsMethodIntegrated | Integrated (0) |
| CredentialsMethodNone | No credentials used (1) |
| CredentialsMethodStored | Use stored credentials (2) |
| CredentialsMethodIntegrated |
| Integrated (0) |
| CredentialsMethodNone |
| No credentials used (1) |
| CredentialsMethodStored |
| Use stored credentials (2) |
| REMARKS |
| * Added in 2007. |
xlCubeFieldSubType |
| Specifies the subtype of the CubeField. |
| xlCubeAttribute | Attribute (4) |
| xlCubeCalculatedMeasure | Calculated Measure (5) |
| xlCubeHierarchy | Hierarchy (1) |
| xlCubeImplicitMeasure | (Added in 2013) |
| xlCubeKPIGoal | KPI Goal (7) |
| xlCubeKPIStatus | KPI Status (8) |
| xlCubeKPITrend | KPI Trend (9) |
| xlCubeKPIValue | KPI Value (6) |
| xlCubeKPIWeight | KPI Weight (10) |
| xlCubeMeasure | Measure (2) |
| xlCubeSet | Set (3) |
| xlCubeAttribute |
| Attribute (4) |
| xlCubeCalculatedMeasure |
| Calculated Measure (5) |
| xlCubeHierarchy |
| Hierarchy (1) |
| xlCubeImplicitMeasure |
| (Added in 2013) |
| xlCubeKPIGoal |
| KPI Goal (7) |
| xlCubeKPIStatus |
| KPI Status (8) |
| xlCubeKPITrend |
| KPI Trend (9) |
| xlCubeKPIValue |
| KPI Value (6) |
| xlCubeKPIWeight |
| KPI Weight (10) |
| xlCubeMeasure |
| Measure (2) |
| xlCubeSet |
| Set (3) |
| REMARKS |
| * Added in 2007. * The values have "Cube" in the name in order to not overlap with the xlMeasure and xlSet values for the CubeFieldType property. * If the names are the same, autocomplete will not work in the Visual Basic environment because it finds ambiguous values. |
xlCubeFieldType |
| Specifies whether the OLAP field is a hierarchy, set, or measure field. |
| xlHierarchy | OLAP field is hierarchy (1) |
| xlMeasure | OLAP field is a measure (2) |
| xlSet | OLAP field is a set (3) |
| xlHierarchy |
| OLAP field is hierarchy (1) |
| xlMeasure |
| OLAP field is a measure (2) |
| xlSet |
| OLAP field is a set (3) |
| REMARKS |
| * Added in 2000. |
xlCutCopyMode |
| Specifies the status of the Cut Copy mode (Long). |
| False | Cancels the Cut or Copy mode and removes the flashing border (0) |
| True | Cancels the Cut or Copy mode and removes the flashing border, On the Macintosh this also places the contents of the selection on to the Macintosh clipboard (?) |
| xlCopy | In Copy mode (1) |
| xlCut | In Cut mode (2) |
| False |
| Cancels the Cut or Copy mode and removes the flashing border (0) |
| True |
| Cancels the Cut or Copy mode and removes the flashing border, On the Macintosh this also places the contents of the selection on to the Macintosh clipboard (?) |
| xlCopy |
| In Copy mode (1) |
| xlCut |
| In Cut mode (2) |
xlCVError |
| Specifies the type of error you want to raise. |
| xlErrBlocked | (Added in 2019) Blocked (2047) |
| xlErrCalc | (Added in 2019) Calculation (2050) |
| xlErrConnect | (Added in 2019) Connect (2046) |
| xlErrDiv0 | Division by Zero (2007) |
| xlErrField | (Added in 2019) Field (2049) |
| xlErrGettingData | (Added in 2019) Getting Data (2043) |
| xlErrNA | NA (2042) |
| xlErrName | Name (2029) |
| xlErrNull | Null (2000) |
| xlErrNum | Num (2036) |
| xlErrRef | Reference (2023) |
| xlErrSpill | (Added in 2019) Spill (2045) |
| xlErrUnknown | (Added in 2019) Unknown (2048) |
| xlErrValue | Value (2015) |
| xlErrBlocked |
| (Added in 2019) Blocked (2047) |
| xlErrCalc |
| (Added in 2019) Calculation (2050) |
| xlErrConnect |
| (Added in 2019) Connect (2046) |
| xlErrDiv0 |
| Division by Zero (2007) |
| xlErrField |
| (Added in 2019) Field (2049) |
| xlErrGettingData |
| (Added in 2019) Getting Data (2043) |
| xlErrNA |
| NA (2042) |
| xlErrName |
| Name (2029) |
| xlErrNull |
| Null (2000) |
| xlErrNum |
| Num (2036) |
| xlErrRef |
| Reference (2023) |
| xlErrSpill |
| (Added in 2019) Spill (2045) |
| xlErrUnknown |
| (Added in 2019) Unknown (2048) |
| xlErrValue |
| Value (2015) |
| REMARKS |
| * This can be used with the VBA.CVErr function to return an error from a custom worksheet function. |
xlDataBarAxisPosition |
| Specifies the axis position for a range of cells with conditional formatting as data bars. |
| xlDataBarAxisAutomatic | Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range (0) |
| xlDataBarAxisMidpoint | Display the axis at the midpoint of the cell regardless of the set of values in the range (1) |
| xlDataBarAxisNone | No axis is displayed, and both positive and negative values are displayed in the left-to-right direction (2) |
| xlDataBarAxisAutomatic |
| Display the axis at a variable position based on the ratio of the minimum negative value to the maximum positive value in the range (0) |
| xlDataBarAxisMidpoint |
| Display the axis at the midpoint of the cell regardless of the set of values in the range (1) |
| xlDataBarAxisNone |
| No axis is displayed, and both positive and negative values are displayed in the left-to-right direction (2) |
| REMARKS |
| * Added in 2010. * When all values are positive or all values are negative, no axis is displayed. * Positive values are displayed in a left-to-right direction. * Negative values are displayed in a right-to-left direction. |
xlDataBarFillType |
| Specifies how a data bar is filled with color. |
| xlDataBarFillGradient | The data bar is filled with a color gradient (1) |
| xlDataBarFillSolid | The data bar is filled with solid color (0) |
| xlDataBarFillGradient |
| The data bar is filled with a color gradient (1) |
| xlDataBarFillSolid |
| The data bar is filled with solid color (0) |
| REMARKS |
| * Added in 2010. |
xlDataBarBorderType |
| Specifies the border of a data bar. |
| xlDataBarBorderNone | The data bar has no border (0) |
| xlDataBarBorderSolid | The data bar has a solid border (1) |
| xlDataBarBorderNone |
| The data bar has no border (0) |
| xlDataBarBorderSolid |
| The data bar has a solid border (1) |
| REMARKS |
| * Added in 2010. |
xlDataBarNegativeColorType |
| Specifies whether to use the same border and fill color as postive data bars. |
| xlDataBarColor | Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object (0) |
| xlDataBarSameAsPositive | Use the same color as positive data bars (1) |
| xlDataBarColor |
| Use the color specified in the Negative Value and Axis Setting dialog box or by using the ColorType and BorderColorType properties of the NegativeBarFormat object (0) |
| xlDataBarSameAsPositive |
| Use the same color as positive data bars (1) |
| REMARKS |
| * Added in 2010. |
xlDeleteShiftDirection |
| Specifies how to shift cells to replace deleted cells. |
| xlShiftToLeft | Cells are shifted to the left (-4159) |
| xlShiftUp | Cells are shifted up (-4162) |
| xlShiftToLeft |
| Cells are shifted to the left (-4159) |
| xlShiftUp |
| Cells are shifted up (-4162) |
xlDirection |
| Specifies the direction in which to move. |
| xlDown | Down (-4121) |
| xlToLeft | To the Left (-4159) |
| xlToRight | To the Right (-4161) |
| xlUp | Up (-4162) |
| xlDown |
| Down (-4121) |
| xlToLeft |
| To the Left (-4159) |
| xlToRight |
| To the Right (-4161) |
| xlUp |
| Up (-4162) |
xlDisplayDrawingObjects |
| Specifies how shapes are displayed. |
| xlDisplayShapes | Show all shapes (-4104) |
| xlHide | Hide all shapes (3) |
| xlPlaceholders | Show only placeholders (2) |
| xlDisplayShapes |
| Show all shapes (-4104) |
| xlHide |
| Hide all shapes (3) |
| xlPlaceholders |
| Show only placeholders (2) |
xlDupeUnique |
| Specifies whether duplicate or unique values shoud be displayed. |
| xlDuplicate | Display duplicate values (1) |
| xlUnique | Display unique values (0) |
| xlDuplicate |
| Display duplicate values (1) |
| xlUnique |
| Display unique values (0) |
| REMARKS |
| * Added in 2007. |
xlDVAlertStyle |
| Specifies the icon used in message boxes displayed during validation. |
| xlValidAlertInformation | Information icon (3) |
| xlValidAlertStop | Stop icon (1) |
| xlValidAlertWarning | Warning icon (2) |
| xlValidAlertInformation |
| Information icon (3) |
| xlValidAlertStop |
| Stop icon (1) |
| xlValidAlertWarning |
| Warning icon (2) |
xlDVType |
| Specifies the type of validation test to be performed in conjunction with values. |
| xlValidateCustom | Data is validated using an arbitrary formula (7) |
| xlValidateDate | Date values (4) |
| xlValidateDecimal | Numeric values (2) |
| xlValidateInputOnly | Validate only when user changes the value (0) |
| xlValidateList | Value must be present in a specified list (3) |
| xlValidateTextLength | Length of text (6) |
| xlValidateTime | Time values (5) |
| xlValidateWholeNumber | Whole numeric values (1) |
| xlValidateCustom |
| Data is validated using an arbitrary formula (7) |
| xlValidateDate |
| Date values (4) |
| xlValidateDecimal |
| Numeric values (2) |
| xlValidateInputOnly |
| Validate only when user changes the value (0) |
| xlValidateList |
| Value must be present in a specified list (3) |
| xlValidateTextLength |
| Length of text (6) |
| xlValidateTime |
| Time values (5) |
| xlValidateWholeNumber |
| Whole numeric values (1) |
xlDynamicFilterCriteria |
| Specifies the filter criterion. |
| xlFilterAboveAverage | Filter all above-average values (33) |
| xlFilterAllDatesInPeriodApril | Filter all dates in April (24) |
| xlFilterAllDatesInPeriodAugust | Filter all dates in August (28) |
| xlFilterAllDatesInPeriodDecember | Filter all dates in December (32) |
| xlFilterAllDatesInPeriodFebruray | Filter all dates in February (22) |
| xlFilterAllDatesInPeriodJanuary | Filter all dates in January (21) |
| xlFilterAllDatesInPeriodJuly | Filter all dates in July (27) |
| xlFilterAllDatesInPeriodJune | Filter all dates in June (26) |
| xlFilterAllDatesInPeriodMarch | Filter all dates in March (23) |
| xlFilterAllDatesInPeriodMay | Filter all dates in May (25) |
| xlFilterAllDatesInPeriodNovember | Filter all dates in November (31) |
| xlFilterAllDatesInPeriodOctober | Filter all dates in October (30) |
| xlFilterAllDatesInPeriodQuarter1 | Filter all dates in Quarter1 (17) |
| xlFilterAllDatesInPeriodQuarter2 | Filter all dates in Quarter2 (18) |
| xlFilterAllDatesInPeriodQuarter3 | Filter all dates in Quarter3 (19) |
| xlFilterAllDatesInPeriodQuarter4 | Filter all dates in Quarter4 (20) |
| xlFilterAllDatesInPeriodSeptember | Filter all dates in September (29) |
| xlFilterBelowAverage | Filter all below-average values (34) |
| xlFilterLastMonth | Filter all values related to last month (8) |
| xlFilterLastQuarter | Filter all values related to last quarter (11) |
| xlFilterLastWeek | Filter all values related to last week (5) |
| xlFilterLastYear | Filter all values related to last year (14) |
| xlFilterNextMonth | Filter all values related to next month (9) |
| xlFilterNextQuarter | Filter all values related to next quarter (12) |
| xlFilterNextWeek | Filter all values related to next week (6) |
| xlFilterNextYear | Filter all values related to next year (15) |
| xlFilterThisMonth | Filter all values related to the current month (7) |
| xlFilterThisQuarter | Filter all values related to the current quarter (10) |
| xlFilterThisWeek | Filter all values related to the current week (4) |
| xlFilterThisYear | Filter all values related to the current year (13) |
| xlFilterToday | Filter all values related to the current date (1) |
| xlFilterTomorrow | Filter all values related to tomorrow (3) |
| xlFilterYearToDate | Filter all values from today until a year ago (16) |
| xlFilterYesterday | Filter all values related to yesterday (2) |
| xlFilterAboveAverage |
| Filter all above-average values (33) |
| xlFilterAllDatesInPeriodApril |
| Filter all dates in April (24) |
| xlFilterAllDatesInPeriodAugust |
| Filter all dates in August (28) |
| xlFilterAllDatesInPeriodDecember |
| Filter all dates in December (32) |
| xlFilterAllDatesInPeriodFebruray |
| Filter all dates in February (22) |
| xlFilterAllDatesInPeriodJanuary |
| Filter all dates in January (21) |
| xlFilterAllDatesInPeriodJuly |
| Filter all dates in July (27) |
| xlFilterAllDatesInPeriodJune |
| Filter all dates in June (26) |
| xlFilterAllDatesInPeriodMarch |
| Filter all dates in March (23) |
| xlFilterAllDatesInPeriodMay |
| Filter all dates in May (25) |
| xlFilterAllDatesInPeriodNovember |
| Filter all dates in November (31) |
| xlFilterAllDatesInPeriodOctober |
| Filter all dates in October (30) |
| xlFilterAllDatesInPeriodQuarter1 |
| Filter all dates in Quarter1 (17) |
| xlFilterAllDatesInPeriodQuarter2 |
| Filter all dates in Quarter2 (18) |
| xlFilterAllDatesInPeriodQuarter3 |
| Filter all dates in Quarter3 (19) |
| xlFilterAllDatesInPeriodQuarter4 |
| Filter all dates in Quarter4 (20) |
| xlFilterAllDatesInPeriodSeptember |
| Filter all dates in September (29) |
| xlFilterBelowAverage |
| Filter all below-average values (34) |
| xlFilterLastMonth |
| Filter all values related to last month (8) |
| xlFilterLastQuarter |
| Filter all values related to last quarter (11) |
| xlFilterLastWeek |
| Filter all values related to last week (5) |
| xlFilterLastYear |
| Filter all values related to last year (14) |
| xlFilterNextMonth |
| Filter all values related to next month (9) |
| xlFilterNextQuarter |
| Filter all values related to next quarter (12) |
| xlFilterNextWeek |
| Filter all values related to next week (6) |
| xlFilterNextYear |
| Filter all values related to next year (15) |
| xlFilterThisMonth |
| Filter all values related to the current month (7) |
| xlFilterThisQuarter |
| Filter all values related to the current quarter (10) |
| xlFilterThisWeek |
| Filter all values related to the current week (4) |
| xlFilterThisYear |
| Filter all values related to the current year (13) |
| xlFilterToday |
| Filter all values related to the current date (1) |
| xlFilterTomorrow |
| Filter all values related to tomorrow (3) |
| xlFilterYearToDate |
| Filter all values from today until a year ago (16) |
| xlFilterYesterday |
| Filter all values related to yesterday (2) |
| REMARKS |
| * Added in 2007. |
xlEditionFormat |
| Specifies the format of the published edition. |
| xlBIFF | Binary Interchange file format (2) |
| xlPICT | Metafile picture structure (.wmf) (1) |
| xlRTF | Rich Text Format (.rtf) (4) |
| xlVALU | VALU (8) |
| xlBIFF |
| Binary Interchange file format (2) |
| xlPICT |
| Metafile picture structure (.wmf) (1) |
| xlRTF |
| Rich Text Format (.rtf) (4) |
| xlVALU |
| VALU (8) |
| REMARKS |
| * This is Macintosh only and should not be used. |
xlEditionOptionsOption |
| This enumeration is for Macintosh only and should not be used. |
| xlAutomaticUpdate | Automatic update (4) |
| xlCancel | Cancel (1) |
| xlChangeAttributes | Change attributes (6) |
| xlManualUpdate | Manual update (5) |
| xlOpenSource | Open source (3) |
| xlSelect | Select (3) |
| xlSendPublisher | Send to Microsoft Publisher (2) |
| xlUpdateSubscriber | Update Subscriber (2) |
| xlAutomaticUpdate |
| Automatic update (4) |
| xlCancel |
| Cancel (1) |
| xlChangeAttributes |
| Change attributes (6) |
| xlManualUpdate |
| Manual update (5) |
| xlOpenSource |
| Open source (3) |
| xlSelect |
| Select (3) |
| xlSendPublisher |
| Send to Microsoft Publisher (2) |
| xlUpdateSubscriber |
| Update Subscriber (2) |
| REMARKS |
| * This is Macintosh only and should not be used. |
xlEditionType |
| Specifies the type of edition to be changed. |
| xlPublisher | Publisher (1) |
| xlSubscriber | Subscriber (2) |
| xlPublisher |
| Publisher (1) |
| xlSubscriber |
| Subscriber (2) |
xlEnableCancelKey |
| Specifies how Microsoft Excel handles Ctrl + Break (or Esc or Command + Period) user interruptions to the running procedure. |
| xlDisabled | All the keystrokes are ignored and trapping is disabled (0) |
| xlErrorHandler | The keystroke is sent to the running procedure as an error that is trappable by an error handler using the On Error GoTo statement This error code is 18 (2) |
| xlInterrupt* | Allows you to interrupt the macro by pressing (Ctrl + Break) (1) |
| xlDisabled |
| All the keystrokes are ignored and trapping is disabled (0) |
| xlErrorHandler |
| The keystroke is sent to the running procedure as an error that is trappable by an error handler using the On Error GoTo statement This error code is 18 (2) |
| xlInterrupt* |
| Allows you to interrupt the macro by pressing (Ctrl + Break) (1) |
xlEnableSelection |
| Specifies what can be selected on the sheet. |
| xlNoRestrictions | Anything can be selected (0) |
| xlNoSelection | Nothing can be selected (-4142) |
| xlUnlockedCells | Only unlocked cells can be selected (1) |
| xlNoRestrictions |
| Anything can be selected (0) |
| xlNoSelection |
| Nothing can be selected (-4142) |
| xlUnlockedCells |
| Only unlocked cells can be selected (1) |
xlErrorChecks |
| Specifies the type of error object to be retrieved from the Errors collection. |
| xlEmptyCellReferences | The cell contains a formula referring to empty cells (7) |
| xlEvaluateToError | The cell evaluates to an error value (1) |
| xlInconsistentFormula | The cell contains an inconsistent formula for a region (4) |
| xlInconsistentListFormula | (Added in 2007) The cell contains an inconsistent formula for a list (9) |
| xlListDataValidation | Data in the list contains a validation error (8) |
| xlNumberAsText | Number entered as text (3) |
| xlOmittedCells | Cells omitted (5) |
| xlTextDate | Date entered as text (2) |
| xlUnlockedFormulaCells | Formula cells are unlocked (6) |
| xlEmptyCellReferences |
| The cell contains a formula referring to empty cells (7) |
| xlEvaluateToError |
| The cell evaluates to an error value (1) |
| xlInconsistentFormula |
| The cell contains an inconsistent formula for a region (4) |
| xlInconsistentListFormula |
| (Added in 2007) The cell contains an inconsistent formula for a list (9) |
| xlListDataValidation |
| Data in the list contains a validation error (8) |
| xlNumberAsText |
| Number entered as text (3) |
| xlOmittedCells |
| Cells omitted (5) |
| xlTextDate |
| Date entered as text (2) |
| xlUnlockedFormulaCells |
| Formula cells are unlocked (6) |
| REMARKS |
| * Added in 2002. |
xlFileAccess |
| Specifies the new access mode for the object. |
| xlReadOnly | Read Only (3) |
| xlReadWrite | Read Write (2) |
| xlReadOnly |
| Read Only (3) |
| xlReadWrite |
| Read Write (2) |
xlFileFormat |
| Specifies the file format when saving the spreadsheet. |
| xlAddIn | Add-in (18) |
| xlAddIn8 | (Added in 2007) Add-in 8 (18) |
| xlCSV | CSV (6) |
| xlCSVMac | CSV Mac (22) |
| xlCSVMSDOS | CSV MS Doc (24) |
| xlCSVWindows | CSV Windows (23) |
| xlCurrentPlatformText | Current Platform Text (-4158) |
| xlDBF2 | DBF2 (7) |
| xlDBF3 | DBF3 (8) |
| xlDBF4 | DBF4 (11) |
| xlDIF | DIF (9) |
| xlExcel2 | Excel 2 (16) |
| xlExcel2FarEast | Excel 2 Far East (27) |
| xlExcel3 | Excel 3 (29) |
| xlExcel4 | Excel 4 (33) |
| xlExcel4Workbook | Excel 4 Workbook (35) |
| xlExcel5 | Excel 5 (39) |
| xlExcel7 | Excel 7 (39) |
| xlExcel8 | (Added in 2007) Excel 8 (56) |
| xlExcel9795 | Excel 97 and 95 (43) |
| xlExcel12 | (Added in 2007) Excel 12 (50) |
| xlHtml | HTML (44) |
| xlIntlAddIn | Intl Addin (26) |
| xlIntlMacro | Intl Macro (25) |
| xlOpenDocumentSpreadsheet | (Added in 2010) Open Document Spreadsheet (60) |
| xlOpenXMLAddIn | (Added in 2007) Open XML Add-in (55) |
| xlOpenXMLStrictWorkbook | (Added in 2013) Open XML Strict Workbook (61) |
| xlOpenXMLTemplate | (Added in 2007) Open XML Template (54) |
| xlOpenXMLTemplateMacroEnabled | (Added in 2007) Open XML Template Macros Enabled (53) |
| xlOpenXMLWorkbook | (Added in 2007) Open XML Workbook (51) |
| xlOpenXMLWorkbookMacroEnabled | (Added in 2007) Open XML Workbook Macros Enabled (52) |
| xlSYLK | SYLK (2) |
| xlTemplate | Template (17) |
| xlTemplate8 | (Added in 2007) Template 8 (17) |
| xlTextMac | Text Mac (19) |
| xlTextMSDOS | Text Microsoft DOS (21) |
| xlTextPrinter | Text Printer (36) |
| xlTextWindows | Text Windows (20) |
| xlUnicodeText | Unicode Text (42) |
| xlWebArchive | Web Archive (45) |
| xlWJ2WD1 | WJ2WD1 (14) |
| xlWJ3 | WJ3 (40) |
| xlWJ3FJ3 | WJ3FJ3 (41) |
| xlWK1 | WK1 (5) |
| xlWK1ALL | WK1ALL (31) |
| xlWK1FMT | WK1FMT (30) |
| xlWK3 | WK3 (15) |
| xlWK3FM3 | WK3FM3 (32) |
| xlWK4 | WK4 (38) |
| xlWKS | WKS (4) |
| xlWorkbookDefault | (Added in 2007) Workbook Default (51) |
| xlWorkbookNormal | Workbook Normal (-4143) |
| xlWorks2FarEast | Works 2 Far East (28) |
| xlWQ1 | WQ1 (34) |
| xlXMLSpreadsheet | XML Spreadsheet (46) |
| xlAddIn |
| Add-in (18) |
| xlAddIn8 |
| (Added in 2007) Add-in 8 (18) |
| xlCSV |
| CSV (6) |
| xlCSVMac |
| CSV Mac (22) |
| xlCSVMSDOS |
| CSV MS Doc (24) |
| xlCSVWindows |
| CSV Windows (23) |
| xlCurrentPlatformText |
| Current Platform Text (-4158) |
| xlDBF2 |
| DBF2 (7) |
| xlDBF3 |
| DBF3 (8) |
| xlDBF4 |
| DBF4 (11) |
| xlDIF |
| DIF (9) |
| xlExcel2 |
| Excel 2 (16) |
| xlExcel2FarEast |
| Excel 2 Far East (27) |
| xlExcel3 |
| Excel 3 (29) |
| xlExcel4 |
| Excel 4 (33) |
| xlExcel4Workbook |
| Excel 4 Workbook (35) |
| xlExcel5 |
| Excel 5 (39) |
| xlExcel7 |
| Excel 7 (39) |
| xlExcel8 |
| (Added in 2007) Excel 8 (56) |
| xlExcel9795 |
| Excel 97 and 95 (43) |
| xlExcel12 |
| (Added in 2007) Excel 12 (50) |
| xlHtml |
| HTML (44) |
| xlIntlAddIn |
| Intl Addin (26) |
| xlIntlMacro |
| Intl Macro (25) |
| xlOpenDocumentSpreadsheet |
| (Added in 2010) Open Document Spreadsheet (60) |
| xlOpenXMLAddIn |
| (Added in 2007) Open XML Add-in (55) |
| xlOpenXMLStrictWorkbook |
| (Added in 2013) Open XML Strict Workbook (61) |
| xlOpenXMLTemplate |
| (Added in 2007) Open XML Template (54) |
| xlOpenXMLTemplateMacroEnabled |
| (Added in 2007) Open XML Template Macros Enabled (53) |
| xlOpenXMLWorkbook |
| (Added in 2007) Open XML Workbook (51) |
| xlOpenXMLWorkbookMacroEnabled |
| (Added in 2007) Open XML Workbook Macros Enabled (52) |
| xlSYLK |
| SYLK (2) |
| xlTemplate |
| Template (17) |
| xlTemplate8 |
| (Added in 2007) Template 8 (17) |
| xlTextMac |
| Text Mac (19) |
| xlTextMSDOS |
| Text Microsoft DOS (21) |
| xlTextPrinter |
| Text Printer (36) |
| xlTextWindows |
| Text Windows (20) |
| xlUnicodeText |
| Unicode Text (42) |
| xlWebArchive |
| Web Archive (45) |
| xlWJ2WD1 |
| WJ2WD1 (14) |
| xlWJ3 |
| WJ3 (40) |
| xlWJ3FJ3 |
| WJ3FJ3 (41) |
| xlWK1 |
| WK1 (5) |
| xlWK1ALL |
| WK1ALL (31) |
| xlWK1FMT |
| WK1FMT (30) |
| xlWK3 |
| WK3 (15) |
| xlWK3FM3 |
| WK3FM3 (32) |
| xlWK4 |
| WK4 (38) |
| xlWKS |
| WKS (4) |
| xlWorkbookDefault |
| (Added in 2007) Workbook Default (51) |
| xlWorkbookNormal |
| Workbook Normal (-4143) |
| xlWorks2FarEast |
| Works 2 Far East (28) |
| xlWQ1 |
| WQ1 (34) |
| xlXMLSpreadsheet |
| XML Spreadsheet (46) |
| REMARKS |
| * xlXMLData (47) this was listed in the MSFT website but is not in the 2003 enumeration ?? |
xlFillWith |
| Specifies how to copy the range. |
| xlFillWithAll | Copy contents and formats (-4104) |
| xlFillWithContents | Copy contents only (2) |
| xlFillWithFormats | Copy formats only (-4122) |
| xlFillWithAll |
| Copy contents and formats (-4104) |
| xlFillWithContents |
| Copy contents only (2) |
| xlFillWithFormats |
| Copy formats only (-4122) |
xlFilterAction |
| Specifies whether data is to be copied or left in place during a filter operation. |
| xlFilterCopy | Copy filtered data to new location (2) |
| xlFilterInPlace | Leave data in place (1) |
| xlFilterCopy |
| Copy filtered data to new location (2) |
| xlFilterInPlace |
| Leave data in place (1) |
xlFilterAllDatesInPeriod |
| Specifies how dates should be filtered in the specified period. |
| xlFilterAllDatesInPeriodDay | Filter all dates for the specified date (2) |
| xlFilterAllDatesInPeriodHour | Filter all dates for the specified hour (3) |
| xlFilterAllDatesInPeriodMinute | Filter all dates until the specified minute (4) |
| xlFilterAllDatesInPeriodMonth | Filter all dates for the specified month (1) |
| xlFilterAllDatesInPeriodSecond | Filter all dates until the specified second (5) |
| xlFilterAllDatesInPeriodYear | Filter all dates for the specified year (0) |
| xlFilterAllDatesInPeriodDay |
| Filter all dates for the specified date (2) |
| xlFilterAllDatesInPeriodHour |
| Filter all dates for the specified hour (3) |
| xlFilterAllDatesInPeriodMinute |
| Filter all dates until the specified minute (4) |
| xlFilterAllDatesInPeriodMonth |
| Filter all dates for the specified month (1) |
| xlFilterAllDatesInPeriodSecond |
| Filter all dates until the specified second (5) |
| xlFilterAllDatesInPeriodYear |
| Filter all dates for the specified year (0) |
| REMARKS |
| * Added in 2007. |
xlFilterStatus |
| Specifies the status of the filter. |
| xlFiltersStatusDateHasTime | Start date or end date have a time portion (2) |
| xlFiltersStatusDateWrongOrder | Start date is greater than end date (1) |
| xlFiltersStatusInvalidDate | Start date or end date are not valid dates (3) |
| xlFiltersStatusOK | Indicates OK or successful (0) |
| xlFiltersStatusDateHasTime |
| Start date or end date have a time portion (2) |
| xlFiltersStatusDateWrongOrder |
| Start date is greater than end date (1) |
| xlFiltersStatusInvalidDate |
| Start date or end date are not valid dates (3) |
| xlFiltersStatusOK |
| Indicates OK or successful (0) |
| REMARKS |
| * Added in 2013. |
xlFindLookIn |
| Specifies the type of data to search. |
| xlComments | Comments (-4144) |
| xlCommentsThreaded | (Added in ??) Threaded comments (-4184) |
| xlFormulas | Formulas (-4123) |
| xlValues | Values (-4163) |
| xlComments |
| Comments (-4144) |
| xlCommentsThreaded |
| (Added in ??) Threaded comments (-4184) |
| xlFormulas |
| Formulas (-4123) |
| xlValues |
| Values (-4163) |
xlFixedFormatQuality |
| Specifies the quality of speadsheets saved in different fixed formats. |
| xlQualityMinimum | Minimum quality (1) |
| xlQualityStandard | Standard quality (0) |
| xlQualityMinimum |
| Minimum quality (1) |
| xlQualityStandard |
| Standard quality (0) |
| REMARKS |
| * Added in 2007. |
xlFixedFormatType |
| Specifies the type of file format. |
| xlTypePDF | "PDF" - Portable Document Format file (.pdf) (0) |
| xlTypeXPS | "XPS" - XPS Document (.xps) (1) |
| xlTypePDF |
| "PDF" - Portable Document Format file (.pdf) (0) |
| xlTypeXPS |
| "XPS" - XPS Document (.xps) (1) |
| REMARKS |
| * Added in 2007. |
xlForecastAggregation |
| Specifies the type of aggregation to use for the forecast. |
| xlForecastAggregationAverage | Average aggregation (1) |
| xlForecastAggregationCount | Count aggregation (2) |
| xlForecastAggregationCountA | CountA aggregation (3) |
| xlForecastAggregationMax | Max aggregation (4) |
| xlForecastAggregationMedian | Median aggregation (5) |
| xlForecastAggregationMin | Minimum aggregation (6) |
| xlForecastAggregationSum | Sum aggregation (7) |
| xlForecastAggregationAverage |
| Average aggregation (1) |
| xlForecastAggregationCount |
| Count aggregation (2) |
| xlForecastAggregationCountA |
| CountA aggregation (3) |
| xlForecastAggregationMax |
| Max aggregation (4) |
| xlForecastAggregationMedian |
| Median aggregation (5) |
| xlForecastAggregationMin |
| Minimum aggregation (6) |
| xlForecastAggregationSum |
| Sum aggregation (7) |
| REMARKS |
| * Added in 2016. |
xlForecastChartType |
| Specifies the type of chart displayed for the forecast. |
| xlForecastChartTypeColumn | Column chart (1) |
| xlForecastChartTypeLine | Line chart (0) |
| xlForecastChartTypeColumn |
| Column chart (1) |
| xlForecastChartTypeLine |
| Line chart (0) |
| REMARKS |
| * Added in 2016. * This is passed to the Workbook.CreateForecastSheet method. |
xlForecastDataCompletion |
| Specifies how data is completed for the forecast. |
| xlForecastDataCompletionInterpolate | Data completion by interpolation (1) |
| xlForecastDataCompletionZeros | Data completion by zeros (0) |
| xlForecastDataCompletionInterpolate |
| Data completion by interpolation (1) |
| xlForecastDataCompletionZeros |
| Data completion by zeros (0) |
| REMARKS |
| * Added in 2016. * This is passed to various worksheet functions and workbook statistical forecasting methods. |
xlFormatFilterTypes |
| Specifies the types of format filters. |
| xlFilterBottom | Bottom (0) |
| xlFilterBottomPercent | Bottom Percent (2) |
| xlFilterTop | Top (1) |
| xlFilterTopPercent | Top Percent (3) |
| xlFilterBottom |
| Bottom (0) |
| xlFilterBottomPercent |
| Bottom Percent (2) |
| xlFilterTop |
| Top (1) |
| xlFilterTopPercent |
| Top Percent (3) |
| REMARKS |
| * Added in 2007. |
xlFormControl |
| Specifies the type of the form control. |
| xlButtonControl | Button (0) |
| xlCheckBox | Check box (1) |
| xlDropDown | Drop down (2) |
| xlEditBox | Edit box (3) |
| xlGroupBox | Group box (4) |
| xlLabel | Label (5) |
| xlListBox | List box (6) |
| xlOptionButton | Option button (7) |
| xlScrollBar | Scroll bar (8) |
| xlSpinner | Spinner (9) |
| xlButtonControl |
| Button (0) |
| xlCheckBox |
| Check box (1) |
| xlDropDown |
| Drop down (2) |
| xlEditBox |
| Edit box (3) |
| xlGroupBox |
| Group box (4) |
| xlLabel |
| Label (5) |
| xlListBox |
| List box (6) |
| xlOptionButton |
| Option button (7) |
| xlScrollBar |
| Scroll bar (8) |
| xlSpinner |
| Spinner (9) |
xlFormulaLabel |
| Specifies the formula label type for the specified range. |
| xlColumnLabels | Column labels only (2) |
| xlMixedLabels | Row and column labels (3) |
| xlNoLabels | No labels (-4142) |
| xlRowLabels | Row labels only (1) |
| xlColumnLabels |
| Column labels only (2) |
| xlMixedLabels |
| Row and column labels (3) |
| xlNoLabels |
| No labels (-4142) |
| xlRowLabels |
| Row labels only (1) |
xlFormulaVersion |
| Specifies how you want formulas replaced when using Range.Replace. |
| xlReplaceFormula | Replace Formula (0) |
| xlReplaceFormula2 | Replace Formula 2 (1) |
| xlReplaceFormula |
| Replace Formula (0) |
| xlReplaceFormula2 |
| Replace Formula 2 (1) |
| REMARKS |
| * Added in 2019. |
xlGenerateTableRefs |
| Specifies the type of table references. |
| xlA1TableRefs | A1 Table References (0) |
| xlTableNames | Table Names (1) |
| xlA1TableRefs |
| A1 Table References (0) |
| xlTableNames |
| Table Names (1) |
| REMARKS |
| * Added in 2007. |
xlHebrewModes |
| Specifies the mode for the Hebrew spelling checker. |
| xlHebrewFullScript | The conventional script type as required by the Hebrew Language Academy when writing text without diacritics (0) |
| xlHebrewMixedAuthorizedScript | The Hebrew traditional script (3) |
| xlHebrewMixedScript | In this mode the speller accepts any word recognised as Hebrew, whether in Full Script, Partial Script or any unconventional spelling varation that is known to the speller (2) |
| xlHebrewPartialScript | In this mode the spelller accepts both in Full Script and Partial Script Some words will be flagged since this spelling is not authorised in either Full Script or Partial script (1) |
| xlHebrewFullScript |
| The conventional script type as required by the Hebrew Language Academy when writing text without diacritics (0) |
| xlHebrewMixedAuthorizedScript |
| The Hebrew traditional script (3) |
| xlHebrewMixedScript |
| In this mode the speller accepts any word recognised as Hebrew, whether in Full Script, Partial Script or any unconventional spelling varation that is known to the speller (2) |
| xlHebrewPartialScript |
| In this mode the spelller accepts both in Full Script and Partial Script Some words will be flagged since this spelling is not authorised in either Full Script or Partial script (1) |
| REMARKS |
| * Added in 2002. |
xlIcon |
| Specifies the icon for a criterion in an icon set conditional formatting rule. |
| xlIcon0Bars | Signal Meter With No Filled Bars (37) |
| xlIcon0FilledBoxes | 0 Filled Boxes (52) |
| xlIcon1Bar | Signal Meter With One Filled Bar (38) |
| xlIcon1FilledBox | 1 Filled Boxes (51) |
| xlIcon2Bars | Signal Meter With Two Filled Bars (39) |
| xlIcon2FilledBoxes | 2 Filled Boxes (50) |
| xlIcon3Bars | Signal Meter With Three Filled Bars (40) |
| xlIcon3FilledBoxes | 3 Filled Boxes (49) |
| xlIcon4Bars | Signal Meter With Four Filled Bars (41) |
| xlIcon4FilledBoxes | 4 Filled Boxes (48) |
| xlIconBlackCircle | Black Circle (32) |
| xlIconBlackCircleWithBorder | Black Circle With Border (13) |
| xlIconCircleWithOneWhiteQuarter | Circle With One White Quarter (33) |
| xlIconCircleWithThreeWhiteQuarters | Circle With Three White Quarters (35) |
| xlIconCircleWithTwoWhiteQuarters | Circle With Two White Quarters (34) |
| xlIconGoldStar | Gold Star (42) |
| xlIconGrayCircle | Gray Circle (31) |
| xlIconGrayDownArrow | Gray Down Arrow (6) |
| xlIconGrayDownInclineArrow | Gray Down Incline Arrow (28) |
| xlIconGraySideArrow | Gray Side Arrow (5) |
| xlIconGrayUpArrow | Gray Up Arrow (4) |
| xlIconGrayUpInclineArrow | Gray Up Incline Arrow (27) |
| xlIconGreenCheck | Green Check (22) |
| xlIconGreenCheckSymbol | Green Check Symbol (19) |
| xlIconGreenCircle | Green Circle (10) |
| xlIconGreenFlag | Green Flag (7) |
| xlIconGreenTrafficLight | Green Traffic Light (14) |
| xlIconGreenUpArrow | Green Up Arrow (1) |
| xlIconGreenUpTriangle | Green Up Triangle (45) |
| xlIconHalfGoldStar | Half Gold Star (43) |
| xlIconNoCellIcon | No Cell Icon (-1) |
| xlIconPinkCircle | Pink Circle (30) |
| xlIconRedCircle | Red Circle (29) |
| xlIconRedCircleWithBorder | Red Circle With Border (12) |
| xlIconRedCross | Red Cross (24) |
| xlIconRedCrossSymbol | Red Cross Symbol (21) |
| xlIconRedDiamond | Red Diamond (18) |
| xlIconRedDownArrow | Red Down Arrow (3) |
| xlIconRedDownTriangle | Red Down Triangle (47) |
| xlIconRedFlag | Red Flag (9) |
| xlIconRedTrafficLight | Red Traffic Light (16) |
| xlIconSilverStar | Silver Star (44) |
| xlIconWhiteCircleAllWhiteQuarters | White Circle (All White Quarters) (36) |
| xlIconYellowCircle | Yellow Circle (11) |
| xlIconYellowDash | Yellow Dash (46) |
| xlIconYellowDownInclineArrow | Yellow Down Incline Arrow (26) |
| xlIconYellowExclamation | Yellow Exclamation (23) |
| xlIconYellowExclamationSymbol | Yellow Exclamation Symbol (20) |
| xlIconYellowFlag | Yellow Flag (8) |
| xlIconYellowSideArrow | Yellow Side Arrow (2) |
| xlIconYellowTrafficLight | Yellow Traffic Light (15) |
| xlIconYellowTriangle | Yellow Triangle (17) |
| xlIconYellowUpInclineArrow | Yellow Up Incline Arrow (25) |
| xlIcon0Bars |
| Signal Meter With No Filled Bars (37) |
| xlIcon0FilledBoxes |
| 0 Filled Boxes (52) |
| xlIcon1Bar |
| Signal Meter With One Filled Bar (38) |
| xlIcon1FilledBox |
| 1 Filled Boxes (51) |
| xlIcon2Bars |
| Signal Meter With Two Filled Bars (39) |
| xlIcon2FilledBoxes |
| 2 Filled Boxes (50) |
| xlIcon3Bars |
| Signal Meter With Three Filled Bars (40) |
| xlIcon3FilledBoxes |
| 3 Filled Boxes (49) |
| xlIcon4Bars |
| Signal Meter With Four Filled Bars (41) |
| xlIcon4FilledBoxes |
| 4 Filled Boxes (48) |
| xlIconBlackCircle |
| Black Circle (32) |
| xlIconBlackCircleWithBorder |
| Black Circle With Border (13) |
| xlIconCircleWithOneWhiteQuarter |
| Circle With One White Quarter (33) |
| xlIconCircleWithThreeWhiteQuarters |
| Circle With Three White Quarters (35) |
| xlIconCircleWithTwoWhiteQuarters |
| Circle With Two White Quarters (34) |
| xlIconGoldStar |
| Gold Star (42) |
| xlIconGrayCircle |
| Gray Circle (31) |
| xlIconGrayDownArrow |
| Gray Down Arrow (6) |
| xlIconGrayDownInclineArrow |
| Gray Down Incline Arrow (28) |
| xlIconGraySideArrow |
| Gray Side Arrow (5) |
| xlIconGrayUpArrow |
| Gray Up Arrow (4) |
| xlIconGrayUpInclineArrow |
| Gray Up Incline Arrow (27) |
| xlIconGreenCheck |
| Green Check (22) |
| xlIconGreenCheckSymbol |
| Green Check Symbol (19) |
| xlIconGreenCircle |
| Green Circle (10) |
| xlIconGreenFlag |
| Green Flag (7) |
| xlIconGreenTrafficLight |
| Green Traffic Light (14) |
| xlIconGreenUpArrow |
| Green Up Arrow (1) |
| xlIconGreenUpTriangle |
| Green Up Triangle (45) |
| xlIconHalfGoldStar |
| Half Gold Star (43) |
| xlIconNoCellIcon |
| No Cell Icon (-1) |
| xlIconPinkCircle |
| Pink Circle (30) |
| xlIconRedCircle |
| Red Circle (29) |
| xlIconRedCircleWithBorder |
| Red Circle With Border (12) |
| xlIconRedCross |
| Red Cross (24) |
| xlIconRedCrossSymbol |
| Red Cross Symbol (21) |
| xlIconRedDiamond |
| Red Diamond (18) |
| xlIconRedDownArrow |
| Red Down Arrow (3) |
| xlIconRedDownTriangle |
| Red Down Triangle (47) |
| xlIconRedFlag |
| Red Flag (9) |
| xlIconRedTrafficLight |
| Red Traffic Light (16) |
| xlIconSilverStar |
| Silver Star (44) |
| xlIconWhiteCircleAllWhiteQuarters |
| White Circle (All White Quarters) (36) |
| xlIconYellowCircle |
| Yellow Circle (11) |
| xlIconYellowDash |
| Yellow Dash (46) |
| xlIconYellowDownInclineArrow |
| Yellow Down Incline Arrow (26) |
| xlIconYellowExclamation |
| Yellow Exclamation (23) |
| xlIconYellowExclamationSymbol |
| Yellow Exclamation Symbol (20) |
| xlIconYellowFlag |
| Yellow Flag (8) |
| xlIconYellowSideArrow |
| Yellow Side Arrow (2) |
| xlIconYellowTrafficLight |
| Yellow Traffic Light (15) |
| xlIconYellowTriangle |
| Yellow Triangle (17) |
| xlIconYellowUpInclineArrow |
| Yellow Up Incline Arrow (25) |
| REMARKS |
| * Added in 2010. |
xlIconSet |
| Specifies the type of icon set. |
| xl3Arrows | 3 Arrow (1) |
| xl3ArrowsGray | 3 Arrows Gra (2) |
| xl3Flags | 3 Flag (3) |
| xl3Signs | 3 Sign (6) |
| xl3Stars | (Added in 2010) |
| xl3Symbols | 3 Symbol (7) |
| xl3TrafficLights1 | 3 Traffic Lights (4) |
| xl3TrafficLights2 | 3 Traffic Lights (5) |
| xl3Triangles | (Added in 2010) |
| xl4Arrows | 4 Arrow (8) |
| xl4ArrowsGray | 4 Arrows Gra (9) |
| xl4CRV | 4 CR (11) |
| xl4RedToBlack | 4 Red To Blac (10) |
| xl4TrafficLights | 4 Traffic Light (12) |
| xl5Arrows | 5 Arrow (13) |
| xl5ArrowsGray | 5 Arrows Gra (14) |
| xl5Boxes | (Added in 2010) |
| xl5CRV | 5 CR (15) |
| xl5Quarters | 5 Quarter (16) |
| xlCustomSet | (Added in 2010) |
| xl3Arrows |
| 3 Arrow (1) |
| xl3ArrowsGray |
| 3 Arrows Gra (2) |
| xl3Flags |
| 3 Flag (3) |
| xl3Signs |
| 3 Sign (6) |
| xl3Stars |
| (Added in 2010) |
| xl3Symbols |
| 3 Symbol (7) |
| xl3TrafficLights1 |
| 3 Traffic Lights (4) |
| xl3TrafficLights2 |
| 3 Traffic Lights (5) |
| xl3Triangles |
| (Added in 2010) |
| xl4Arrows |
| 4 Arrow (8) |
| xl4ArrowsGray |
| 4 Arrows Gra (9) |
| xl4CRV |
| 4 CR (11) |
| xl4RedToBlack |
| 4 Red To Blac (10) |
| xl4TrafficLights |
| 4 Traffic Light (12) |
| xl5Arrows |
| 5 Arrow (13) |
| xl5ArrowsGray |
| 5 Arrows Gra (14) |
| xl5Boxes |
| (Added in 2010) |
| xl5CRV |
| 5 CR (15) |
| xl5Quarters |
| 5 Quarter (16) |
| xlCustomSet |
| (Added in 2010) |
| REMARKS |
| * Added in 2007. |
xlIMEMode |
| Specifies the description of the Japanese input rules. |
| xlIMEModeAlpha | Alpha (8) |
| xlIMEModeAlphaFull | Alpha Full (7) |
| xlIMEModeDisable | Disable (3) |
| xlIMEModeHangul | Hangul (10) |
| xlIMEModeHangulFull | Hangul Full (9) |
| xlIMEModeHiragana | Hiragana (4) |
| xlIMEModeKatakana | Katakana (5) |
| xlIMEModeKatakanaHalf | Katakana Half (6) |
| xlIMEModeNoControl | No Control (0) |
| xlIMEModeOff | Off (2) |
| xlIMEModeOn | On (1) |
| xlIMEModeAlpha |
| Alpha (8) |
| xlIMEModeAlphaFull |
| Alpha Full (7) |
| xlIMEModeDisable |
| Disable (3) |
| xlIMEModeHangul |
| Hangul (10) |
| xlIMEModeHangulFull |
| Hangul Full (9) |
| xlIMEModeHiragana |
| Hiragana (4) |
| xlIMEModeKatakana |
| Katakana (5) |
| xlIMEModeKatakanaHalf |
| Katakana Half (6) |
| xlIMEModeNoControl |
| No Control (0) |
| xlIMEModeOff |
| Off (2) |
| xlIMEModeOn |
| On (1) |
xlImportDataAs |
| Specifies the format in which to return data from a database. |
| xlPivotTableReport | Pivot Table Report (1) |
| xlQueryTable | Query Table (0) |
| xlTable | (Added in 2007) Table (2) |
| xlPivotTableReport |
| Pivot Table Report (1) |
| xlQueryTable |
| Query Table (0) |
| xlTable |
| (Added in 2007) Table (2) |
| REMARKS |
| * Added in 2002. |
xlInsertFormatOrigin |
| Specifies from where to copy the format for inserted rows. |
| xlFormatFromLeftOrAbove | From Left Or Above (0) |
| xlFormatFromRightOrBelow | From Right Or Below (1) |
| xlFormatFromLeftOrAbove |
| From Left Or Above (0) |
| xlFormatFromRightOrBelow |
| From Right Or Below (1) |
| REMARKS |
| * Added in 2002. |
xlInsertShiftDirection |
| Specifies the direction in which to shift cells during an insertion. |
| xlShiftDown | Shift Down (-4121) |
| xlShiftToRight | Shift To Right (-4161) |
| xlShiftDown |
| Shift Down (-4121) |
| xlShiftToRight |
| Shift To Right (-4161) |
xlLayoutRowType |
| Specifies the type of layout row. |
| xlCompactRow | Compact Row (0) |
| xlOutlineRow | Outline Row (2) |
| xlTabularRow | Tabular Row (1) |
| xlCompactRow |
| Compact Row (0) |
| xlOutlineRow |
| Outline Row (2) |
| xlTabularRow |
| Tabular Row (1) |
| REMARKS |
| * Added in 2007. |
xlLinkedDataTypeState |
| Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| xlLinkedDataTypeStateBrokenLinkedData | There is a valid Linked data type in the cell, but entity no longer exists on the service (3) |
| xlLinkedDataTypeStateDisambiguationNeeded | The cell needs to be disambiguated by the user before a Linked data type can be inserted For example, if the user types "New York" into a cell and attempts to convert it to a "Geography" data type, they may need to select whether they meant New York State or New York City Until they do so, the cell will be in this state (2) |
| xlLinkedDataTypeStateFetchingData | The Linked data type in the cell is in the middle of refreshing new data from the service (4) |
| xlLinkedDataTypeStateNone | The cell does not contain any Linked data types (0) |
| xlLinkedDataTypeStateValidLinkedData | The cell contains a Linked data type (1) |
| xlLinkedDataTypeStateBrokenLinkedData |
| There is a valid Linked data type in the cell, but entity no longer exists on the service (3) |
| xlLinkedDataTypeStateDisambiguationNeeded |
| The cell needs to be disambiguated by the user before a Linked data type can be inserted For example, if the user types "New York" into a cell and attempts to convert it to a "Geography" data type, they may need to select whether they meant New York State or New York City Until they do so, the cell will be in this state (2) |
| xlLinkedDataTypeStateFetchingData |
| The Linked data type in the cell is in the middle of refreshing new data from the service (4) |
| xlLinkedDataTypeStateNone |
| The cell does not contain any Linked data types (0) |
| xlLinkedDataTypeStateValidLinkedData |
| The cell contains a Linked data type (1) |
| REMARKS |
| * Added in 2019. |
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. |
| xlListConflictDialog | Dialog (0) |
| xlListConflictDiscardAllConflicts | Discard All Conflicts (2) |
| xlListConflictError | Error (3) |
| xlListConflictRetryAllConflicts | Retry All Conflicts (1) |
| xlListConflictDialog |
| Dialog (0) |
| xlListConflictDiscardAllConflicts |
| Discard All Conflicts (2) |
| xlListConflictError |
| Error (3) |
| xlListConflictRetryAllConflicts |
| Retry All Conflicts (1) |
xlListObjectSourceType |
| Specifies the current source of the list. |
| xlSrcExternal | External (0) |
| xlSrcModel | (Added in 2013) Model (4) |
| xlSrcQuery | (Added in 2007) Query (3) |
| xlSrcRange | Range (1) |
| xlSrcXml | XML (2) |
| xlSrcExternal |
| External (0) |
| xlSrcModel |
| (Added in 2013) Model (4) |
| xlSrcQuery |
| (Added in 2007) Query (3) |
| xlSrcRange |
| Range (1) |
| xlSrcXml |
| XML (2) |
xlLookAt |
| Specifies whether a match is made against the whole of the search text or any part of the search text. |
| xlPart | Part (2) |
| xlWhole | Whole (1) |
| xlPart |
| Part (2) |
| xlWhole |
| Whole (1) |
xlLookFor |
| Specifies what to look for in searches. |
| LookForBlanks | Blank (0) |
| LookForErrors | Error (1) |
| LookForFormulas | Formula (2) |
| LookForBlanks |
| Blank (0) |
| LookForErrors |
| Error (1) |
| LookForFormulas |
| Formula (2) |
| REMARKS |
| * Added in 2007. |
xlMailSystem |
| Specifies the mail system that is installed on the host machine. |
| xlMAPI | Messaging Application Program Interface This is a Microsoft standard (1) |
| xlNoMailSystem | No email system is available (none at least that are compatible with either MAPI or PowerTalk (0) |
| xlPowerTalk | PowerTalk This is a Macintosh standard (2) |
| xlMAPI |
| Messaging Application Program Interface This is a Microsoft standard (1) |
| xlNoMailSystem |
| No email system is available (none at least that are compatible with either MAPI or PowerTalk (0) |
| xlPowerTalk |
| PowerTalk This is a Macintosh standard (2) |
xlMeasurementUnits |
| Specifies the measurement units. |
| xlCentimeters | Centimeters (1) |
| xlInches | Inches (0) |
| xlMillimeters | Millimeters (2) |
| xlCentimeters |
| Centimeters (1) |
| xlInches |
| Inches (0) |
| xlMillimeters |
| Millimeters (2) |
| REMARKS |
| * Added in 2007. |
xlModelChangeSource |
| Specifies the source of the change to the data model. |
| xlChangeByExcel | Excel (0) |
| xlChangeByPowerPivotAddIn | PowerPivot add-in (1) |
| xlChangeByExcel |
| Excel (0) |
| xlChangeByPowerPivotAddIn |
| PowerPivot add-in (1) |
| REMARKS |
| * Added in 2013. |
xlMouseButton |
| Specifies which mouse button was pressed. |
| xlNoButton | No Button (0) |
| xlPrimaryButton | Primary Button (1) |
| xlSecondaryButton | Secondary Button (2) |
| xlNoButton |
| No Button (0) |
| xlPrimaryButton |
| Primary Button (1) |
| xlSecondaryButton |
| Secondary Button (2) |
xlMousePointer |
| Specifies the appearance of the mouse pointer in Microsoft Excel. |
| xlDefault | Default (-4143) |
| xlIBeam | Beam (3) |
| xlNorthwestArrow | Northwest Arrow (1) |
| xlWait | Wait (2) |
| xlDefault |
| Default (-4143) |
| xlIBeam |
| Beam (3) |
| xlNorthwestArrow |
| Northwest Arrow (1) |
| xlWait |
| Wait (2) |
xlMSApplication |
| Specifies a Microsoft application. |
| xlMicrosoftAccess | Access (4) |
| xlMicrosoftFoxPro | FoxPro (5) |
| xlMicrosoftMail | Mail (3) |
| xlMicrosoftPowerPoint | PowerPoint (2) |
| xlMicrosoftProject | Project (6) |
| xlMicrosoftSchedulePlus | Schedule Plus (7) |
| xlMicrosoftWord | Word (1) |
| xlMicrosoftAccess |
| Access (4) |
| xlMicrosoftFoxPro |
| FoxPro (5) |
| xlMicrosoftMail |
| Mail (3) |
| xlMicrosoftPowerPoint |
| PowerPoint (2) |
| xlMicrosoftProject |
| Project (6) |
| xlMicrosoftSchedulePlus |
| Schedule Plus (7) |
| xlMicrosoftWord |
| Word (1) |
xlOartHorizontalOverflow |
| Specifies the horizontal overflow setting for a text frame. |
| xlOartHorizontalOverflowClip | Hide text that does not fit horizontally in the text frame (1) |
| xlOartHorizontalOverflowOverflow | Allow text to overflow the text frame horizontally (0) |
| xlOartHorizontalOverflowClip |
| Hide text that does not fit horizontally in the text frame (1) |
| xlOartHorizontalOverflowOverflow |
| Allow text to overflow the text frame horizontally (0) |
| REMARKS |
| * Added in 2010. |
xlOartVerticalOverflow |
| Specifies the vertical overflow setting for a text frame. |
| xlOartVerticalOverflowClip | Hide text that does not fit vertically within the text frame (1) |
| xlOartVerticalOverflowEllipsis | Hide text that does not fit vertically within the text frame, and add an ellipsis (...) at the end of the visible text (2) |
| xlOartVerticalOverflowOverflow | Allow text to overflow the text frame vertically (can be from the top, bottom, or both depending on the text alignment) (0) |
| xlOartVerticalOverflowClip |
| Hide text that does not fit vertically within the text frame (1) |
| xlOartVerticalOverflowEllipsis |
| Hide text that does not fit vertically within the text frame, and add an ellipsis (...) at the end of the visible text (2) |
| xlOartVerticalOverflowOverflow |
| Allow text to overflow the text frame vertically (can be from the top, bottom, or both depending on the text alignment) (0) |
| REMARKS |
| * Added in 2010. |
xlOLEType |
| Specifies the OLE object type. |
| xlOLEControl | Control (2) |
| xlOLEEmbed | Embed (1) |
| xlOLELink | Link (0) |
| xlOLEControl |
| Control (2) |
| xlOLEEmbed |
| Embed (1) |
| xlOLELink |
| Link (0) |
xlOLEVerb |
| Specifies the verb that the server of the OLE object should act on. |
| xlVerbOpen | Open (2) |
| xlVerbPrimary | Primary (1) |
| xlVerbOpen |
| Open (2) |
| xlVerbPrimary |
| Primary (1) |
xlOrder |
| Specifies the order in which cells are processed. |
| xlDownThenOver | Down Then Over (1) |
| xlOverThenDown | Over Then Down (2) |
| xlDownThenOver |
| Down Then Over (1) |
| xlOverThenDown |
| Over Then Down (2) |
xlOrientation |
| Specifies the text orientation. |
| xlDownward | Text runs downward (-4170) |
| xlHorizontal | Text runs horizontally (-4128) |
| xlUpward | Text runs upward (-4171) |
| xlVertical | Text runs downward and is centered (-4166) |
| xlDownward |
| Text runs downward (-4170) |
| xlHorizontal |
| Text runs horizontally (-4128) |
| xlUpward |
| Text runs upward (-4171) |
| xlVertical |
| Text runs downward and is centered (-4166) |
| REMARKS |
| * Used by the Axis.AxisTitle.Orientation |
xlPageBreak |
| Specifies page break location in the worksheet. |
| xlPageBreakAutomatic | Automatic (-4105) |
| xlPageBreakManual | Manual (-4135) |
| xlPageBreakNone | None (-4142) |
| xlPageBreakAutomatic |
| Automatic (-4105) |
| xlPageBreakManual |
| Manual (-4135) |
| xlPageBreakNone |
| None (-4142) |
xlPageBreakExtent |
| Specifies whether a page break is full screen or applies only within the print area. |
| xlPageBreakFull | Full (1) |
| xlPageBreakPartial | Partial (2) |
| xlPageBreakFull |
| Full (1) |
| xlPageBreakPartial |
| Partial (2) |
xlPageOrientation |
| Specifies the page orientation when the worksheet is printed. |
| xlLandscape | 2 |
| xlPortrait | 1 |
| xlLandscape |
| 2 |
| xlPortrait |
| 1 |
xlParameterDataType |
| Specifies the data type of a query parameter. |
| xlParamTypeBigInt | -5 |
| xlParamTypeBinary | -2 |
| xlParamTypeBit | -7 |
| xlParamTypeChar | 1 |
| xlParamTypeDate | 9 |
| xlParamTypeDecimal | 3 |
| xlParamTypeDouble | 8 |
| xlParamTypeFloat | 6 |
| xlParamTypeInteger | 4 |
| xlParamTypeLongVarBinary | -4 |
| xlParamTypeLongVarChar | -1 |
| xlParamTypeNumeric | 2 |
| xlParamTypeReal | 7 |
| xlParamTypeSmallInt | 5 |
| xlParamTypeTime | 10 |
| xlParamTypeTimestamp | 11 |
| xlParamTypeTinyInt | -6 |
| xlParamTypeUnknown | 0 |
| xlParamTypeVarBinary | -3 |
| xlParamTypeVarChar | 12 |
| xlParamTypeWChar | -8 |
| xlParamTypeBigInt |
| -5 |
| xlParamTypeBinary |
| -2 |
| xlParamTypeBit |
| -7 |
| xlParamTypeChar |
| 1 |
| xlParamTypeDate |
| 9 |
| xlParamTypeDecimal |
| 3 |
| xlParamTypeDouble |
| 8 |
| xlParamTypeFloat |
| 6 |
| xlParamTypeInteger |
| 4 |
| xlParamTypeLongVarBinary |
| -4 |
| xlParamTypeLongVarChar |
| -1 |
| xlParamTypeNumeric |
| 2 |
| xlParamTypeReal |
| 7 |
| xlParamTypeSmallInt |
| 5 |
| xlParamTypeTime |
| 10 |
| xlParamTypeTimestamp |
| 11 |
| xlParamTypeTinyInt |
| -6 |
| xlParamTypeUnknown |
| 0 |
| xlParamTypeVarBinary |
| -3 |
| xlParamTypeVarChar |
| 12 |
| xlParamTypeWChar |
| -8 |
xlParameterType |
| Specifies how to determine the value of the parameter for the specified query table. |
| xlConstant | 1 |
| xlPrompt | 0 |
| xlRange | 2 |
| xlConstant |
| 1 |
| xlPrompt |
| 0 |
| xlRange |
| 2 |
xlParentDataLabelOptions |
| Specifies the values passed to and returned from the Series.ParentDataLabelOption property. |
| xlParentDataLabelOptionsBanner | Banner parent data label (1) |
| xlParentDataLabelOptionsNone | No parent data label (0) |
| xlParentDataLabelOptionsOverlapping | Overlapping parent data label (2) |
| xlParentDataLabelOptionsBanner |
| Banner parent data label (1) |
| xlParentDataLabelOptionsNone |
| No parent data label (0) |
| xlParentDataLabelOptionsOverlapping |
| Overlapping parent data label (2) |
| REMARKS |
| * Added in 2016. |
xlPasteSpecialOperation |
| Specifies the operation you want to perform. |
| xlPasteSpecialOperationAdd | 2 |
| xlPasteSpecialOperationDivide | 5 |
| xlPasteSpecialOperationMultiply | 4 |
| xlPasteSpecialOperationNone | -4142 |
| xlPasteSpecialOperationSubtract | 3 |
| xlPasteSpecialOperationAdd |
| 2 |
| xlPasteSpecialOperationDivide |
| 5 |
| xlPasteSpecialOperationMultiply |
| 4 |
| xlPasteSpecialOperationNone |
| -4142 |
| xlPasteSpecialOperationSubtract |
| 3 |
| REMARKS |
| * Instead of xlPasteSpecialOperationNone you could use xlNone = (-4142) |
xlPasteType |
| Specifies the part of the range you want to paste. |
| xlPasteAll | (-4104) |
| xlPasteAllExceptBorders | (7) |
| xlPasteAllMergingConditionalFormats | (Added in 2010) Everything will be pasted and conditional formats will be merged (14) |
| xlPasteAllUsingSourceTheme | (Added in 2007) (13) |
| xlPasteColumnWidths | (8) |
| xlPasteComments | (-4144) |
| xlPasteFormats | (-4122) |
| xlPasteFormulas | (-4123) |
| xlPasteFormulasAndNumberFormats | (11) |
| xlPasteValidation | (6) |
| xlPasteValues | (-4163) |
| xlPasteValuesAndNumberFormats | (12) |
| xlPasteAll |
| (-4104) |
| xlPasteAllExceptBorders |
| (7) |
| xlPasteAllMergingConditionalFormats |
| (Added in 2010) Everything will be pasted and conditional formats will be merged (14) |
| xlPasteAllUsingSourceTheme |
| (Added in 2007) (13) |
| xlPasteColumnWidths |
| (8) |
| xlPasteComments |
| (-4144) |
| xlPasteFormats |
| (-4122) |
| xlPasteFormulas |
| (-4123) |
| xlPasteFormulasAndNumberFormats |
| (11) |
| xlPasteValidation |
| (6) |
| xlPasteValues |
| (-4163) |
| xlPasteValuesAndNumberFormats |
| (12) |
xlPhoneticAlignment |
| Specifies the alignment for phonetic text. |
| xlPhoneticAlignCenter | 2 |
| xlPhoneticAlignDistributed | 3 |
| xlPhoneticAlignLeft | 1 |
| xlPhoneticAlignNoControl | 0 |
| xlPhoneticAlignCenter |
| 2 |
| xlPhoneticAlignDistributed |
| 3 |
| xlPhoneticAlignLeft |
| 1 |
| xlPhoneticAlignNoControl |
| 0 |
xlPhoneticCharacterType |
| Specifies the type of phonetic text in a cell. |
| xlHiragana | 2 |
| xlKatakana | 1 |
| xlKatakanaHalf | 0 |
| xlNoConversion | 3 |
| xlHiragana |
| 2 |
| xlKatakana |
| 1 |
| xlKatakanaHalf |
| 0 |
| xlNoConversion |
| 3 |
xlPictureAppearance |
| Specifies how the picture should be copied. |
| xlPrinter | 2 |
| xlScreen | 1 |
| xlPrinter |
| 2 |
| xlScreen |
| 1 |
xlPictureConvertorType |
| Specifies how to convert a graphic. |
| xlBMP | 1 |
| xlCGM | 7 |
| xlDRW | 4 |
| xlDXF | 5 |
| xlEPS | 8 |
| xlHGL | 6 |
| xlPCT | 13 |
| xlPCX | 10 |
| xlPIC | 11 |
| xlPLT | 12 |
| xlTIF | 9 |
| xlWMF | 2 |
| xlWPG | 3 |
| xlBMP |
| 1 |
| xlCGM |
| 7 |
| xlDRW |
| 4 |
| xlDXF |
| 5 |
| xlEPS |
| 8 |
| xlHGL |
| 6 |
| xlPCT |
| 13 |
| xlPCX |
| 10 |
| xlPIC |
| 11 |
| xlPLT |
| 12 |
| xlTIF |
| 9 |
| xlWMF |
| 2 |
| xlWPG |
| 3 |
xlPlacement |
| Specifies the way an object is attached to its underlying cells. |
| xlFreeFloating | Object is free floating (3) |
| xlMove | Object is moved with the cells (2) |
| xlMoveAndSize | Object is moved and sized with the cells (1) |
| xlFreeFloating |
| Object is free floating (3) |
| xlMove |
| Object is moved with the cells (2) |
| xlMoveAndSize |
| Object is moved and sized with the cells (1) |
xlPlatform |
| Specifies the platform that a text file originated on. |
| xlMacintosh | 1 |
| xlMSDOS | 3 |
| xlWindows | 2 |
| xlMacintosh |
| 1 |
| xlMSDOS |
| 3 |
| xlWindows |
| 2 |
xlPortugueseReform |
| Specifies the mode for checking the spelling of Portuguese. |
| xlPortuguesePreReform | The spelling checker recognizes only pre-reform spellings (1) |
| xlPortuguesePostReform | The spelling checker recognizes only post-reform spellings (2) |
| xlPortugueseBoth | The spelling checker recognizes both pre-reform and post-reform spellings (3) |
| xlPortuguesePreReform |
| The spelling checker recognizes only pre-reform spellings (1) |
| xlPortuguesePostReform |
| The spelling checker recognizes only post-reform spellings (2) |
| xlPortugueseBoth |
| The spelling checker recognizes both pre-reform and post-reform spellings (3) |
| REMARKS |
| * Added in 2010. |
xlPriority |
| Specifies the priority of a SendMailer message. |
| xlPriorityHigh | -4127 |
| xlPriorityLow | -4134 |
| xlPriorityNormal | -4143 |
| xlPriorityHigh |
| -4127 |
| xlPriorityLow |
| -4134 |
| xlPriorityNormal |
| -4143 |
xlPropertyDisplayedIn |
| Specifies where to display the property. |
| xlDisplayPropertyInPivotTable | Displays member property in the PivotTable only This is the default value (1) |
| xlDisplayPropertyInPivotTableAndTooltip | Displays member property in the tooltip only (3) |
| xlDisplayPropertyInTooltip | Displays member property in both the tooltip and the PivotTable (2) |
| xlDisplayPropertyInPivotTable |
| Displays member property in the PivotTable only This is the default value (1) |
| xlDisplayPropertyInPivotTableAndTooltip |
| Displays member property in the tooltip only (3) |
| xlDisplayPropertyInTooltip |
| Displays member property in both the tooltip and the PivotTable (2) |
| REMARKS |
| * Added in 2007. |
xlProtectedViewCloseReason |
| Specifies how the protected view window was closed. |
| xlProtectedViewCloseEdit | The window was closed when the user clicked the Enable Editing button (1) |
| xlProtectedViewCloseForced | The window was closed because the application shut it down forcefully or stopped responding (2) |
| xlProtectedViewCloseNormal | The window was closed normally (0) |
| xlProtectedViewCloseEdit |
| The window was closed when the user clicked the Enable Editing button (1) |
| xlProtectedViewCloseForced |
| The window was closed because the application shut it down forcefully or stopped responding (2) |
| xlProtectedViewCloseNormal |
| The window was closed normally (0) |
| REMARKS |
| * Added in 2010. |
xlProtectedViewWIndowState |
| Specifies the state of the protected view window. |
| xlProtectedViewWindowMaximized | Maximized (2) |
| xlProtectedViewWindowMinimized | Minimized (1) |
| xlProtectedViewWindowNormal | Normal (0) |
| xlProtectedViewWindowMaximized |
| Maximized (2) |
| xlProtectedViewWindowMinimized |
| Minimized (1) |
| xlProtectedViewWindowNormal |
| Normal (0) |
| REMARKS |
| * Added in 2010. |
xlPublishToDocsDisclosureScope |
| Specifies the disclosure type when publishing a workbook to a document. |
| msoLimited | (1) |
| msoNoOverwrite | (3) |
| msoOrganization | (2) |
| msoPublic | (0) |
| msoLimited |
| (1) |
| msoNoOverwrite |
| (3) |
| msoOrganization |
| (2) |
| msoPublic |
| (0) |
| REMARKS |
| * Added in 2016. * Not all 2016 versions have this because it was included in an update. |
xlPublishToPBINameConflictAction |
| Specifies the conflict action when publishing to Power BI. |
| msoPBIAbort | (1) |
| msoPBIIgnore | (0) |
| msoPBIOverwrite | (2) |
| msoPBIAbort |
| (1) |
| msoPBIIgnore |
| (0) |
| msoPBIOverwrite |
| (2) |
| REMARKS |
| * Added in 2016. * Not all 2016 versions have this because it was included in an update. |
xlPublishToPBIPublishType |
| Specifies the publishing type when publishing to Power BI. |
| msoPBIExport | (0) |
| msoPBIUpload | (1) |
| msoPBIExport |
| (0) |
| msoPBIUpload |
| (1) |
| REMARKS |
| * Added in 2016. * Not all 2016 versions have this because it was included in an update. |
xlQuickAnalysisMode |
| Specifies which top level button the callout user interface is displayed. |
| xlFormatConditions | Conditional formatting (1) |
| xlLensOnly | Show the button but no callout user interface (0) |
| xlRecommendedCharts | Charts (2) |
| xlSparklines | Sparklines (5) |
| xlTables | Tables(4) |
| xlTotals | Totals (3) |
| xlFormatConditions |
| Conditional formatting (1) |
| xlLensOnly |
| Show the button but no callout user interface (0) |
| xlRecommendedCharts |
| Charts (2) |
| xlSparklines |
| Sparklines (5) |
| xlTables |
| Tables(4) |
| xlTotals |
| Totals (3) |
| REMARKS |
| * Added in 2013. |
xlRangeAutoFormat |
| Specifies the predefined format when a range is automatically formatted. |
| xlRangeAutoFormat3DEffects1 | 13 |
| xlRangeAutoFormat3DEffects2 | 14 |
| xlRangeAutoFormatAccounting1 | 4 |
| xlRangeAutoFormatAccounting2 | 5 |
| xlRangeAutoFormatAccounting3 | 6 |
| xlRangeAutoFormatAccounting4 | 17 |
| xlRangeAutoFormatClassic1 | 1 |
| xlRangeAutoFormatClassic2 | 2 |
| xlRangeAutoFormatClassic3 | 3 |
| xlRangeAutoFormatClassicPivotTable | 31 |
| xlRangeAutoFormatColor1 | 7 |
| xlRangeAutoFormatColor2 | 8 |
| xlRangeAutoFormatColor3 | 9 |
| xlRangeAutoFormatList1 | 10 |
| xlRangeAutoFormatList2 | 11 |
| xlRangeAutoFormatList3 | 12 |
| xlRangeAutoFormatLocalFormat1 | 15 |
| xlRangeAutoFormatLocalFormat2 | 16 |
| xlRangeAutoFormatLocalFormat3 | 19 |
| xlRangeAutoFormatLocalFormat4 | 20 |
| xlRangeAutoFormatNone | -4142 |
| xlRangeAutoFormatPTNone | 42 |
| xlRangeAutoFormatReport1 | 21 |
| xlRangeAutoFormatReport10 | 30 |
| xlRangeAutoFormatReport2 | 22 |
| xlRangeAutoFormatReport3 | 23 |
| xlRangeAutoFormatReport4 | 24 |
| xlRangeAutoFormatReport5 | 25 |
| xlRangeAutoFormatReport6 | 26 |
| xlRangeAutoFormatReport7 | 27 |
| xlRangeAutoFormatReport8 | 28 |
| xlRangeAutoFormatReport9 | 29 |
| xlRangeAutoFormatSimple | -4154 |
| xlRangeAutoFormatTable1 | 32 |
| xlRangeAutoFormatTable10 | 41 |
| xlRangeAutoFormatTable2 | 33 |
| xlRangeAutoFormatTable3 | 34 |
| xlRangeAutoFormatTable4 | 35 |
| xlRangeAutoFormatTable5 | 36 |
| xlRangeAutoFormatTable6 | 37 |
| xlRangeAutoFormatTable7 | 38 |
| xlRangeAutoFormatTable8 | 39 |
| xlRangeAutoFormatTable9 | 40 |
| xlRangeAutoFormat3DEffects1 |
| 13 |
| xlRangeAutoFormat3DEffects2 |
| 14 |
| xlRangeAutoFormatAccounting1 |
| 4 |
| xlRangeAutoFormatAccounting2 |
| 5 |
| xlRangeAutoFormatAccounting3 |
| 6 |
| xlRangeAutoFormatAccounting4 |
| 17 |
| xlRangeAutoFormatClassic1 |
| 1 |
| xlRangeAutoFormatClassic2 |
| 2 |
| xlRangeAutoFormatClassic3 |
| 3 |
| xlRangeAutoFormatClassicPivotTable |
| 31 |
| xlRangeAutoFormatColor1 |
| 7 |
| xlRangeAutoFormatColor2 |
| 8 |
| xlRangeAutoFormatColor3 |
| 9 |
| xlRangeAutoFormatList1 |
| 10 |
| xlRangeAutoFormatList2 |
| 11 |
| xlRangeAutoFormatList3 |
| 12 |
| xlRangeAutoFormatLocalFormat1 |
| 15 |
| xlRangeAutoFormatLocalFormat2 |
| 16 |
| xlRangeAutoFormatLocalFormat3 |
| 19 |
| xlRangeAutoFormatLocalFormat4 |
| 20 |
| xlRangeAutoFormatNone |
| -4142 |
| xlRangeAutoFormatPTNone |
| 42 |
| xlRangeAutoFormatReport1 |
| 21 |
| xlRangeAutoFormatReport10 |
| 30 |
| xlRangeAutoFormatReport2 |
| 22 |
| xlRangeAutoFormatReport3 |
| 23 |
| xlRangeAutoFormatReport4 |
| 24 |
| xlRangeAutoFormatReport5 |
| 25 |
| xlRangeAutoFormatReport6 |
| 26 |
| xlRangeAutoFormatReport7 |
| 27 |
| xlRangeAutoFormatReport8 |
| 28 |
| xlRangeAutoFormatReport9 |
| 29 |
| xlRangeAutoFormatSimple |
| -4154 |
| xlRangeAutoFormatTable1 |
| 32 |
| xlRangeAutoFormatTable10 |
| 41 |
| xlRangeAutoFormatTable2 |
| 33 |
| xlRangeAutoFormatTable3 |
| 34 |
| xlRangeAutoFormatTable4 |
| 35 |
| xlRangeAutoFormatTable5 |
| 36 |
| xlRangeAutoFormatTable6 |
| 37 |
| xlRangeAutoFormatTable7 |
| 38 |
| xlRangeAutoFormatTable8 |
| 39 |
| xlRangeAutoFormatTable9 |
| 40 |
xlRangeValueDataType |
| Specifies the range value data type. |
| xlRangeValueDefault | 10 |
| xlRangeValueMSPersistXML | 12 |
| xlRangeValueXMLSpreadsheet | 11 |
| xlRangeValueDefault |
| 10 |
| xlRangeValueMSPersistXML |
| 12 |
| xlRangeValueXMLSpreadsheet |
| 11 |
| REMARKS |
| * Added in 2002. |
xlReferenceStyle |
| Specifies the reference style. |
| xlA1* | Returns an A1-style reference (1) |
| xlR1C1 | Returns an R1C1-style reference (-4150) |
| xlA1* |
| Returns an A1-style reference (1) |
| xlR1C1 |
| Returns an R1C1-style reference (-4150) |
xlReferenceType |
| Specifies cell reference style when a formula is being converted. |
| xlAbsolute | 1 |
| xlAbsRowRelColumn | 2 |
| xlRelative | 4 |
| xlRelRowAbsColumn | 3 |
| xlAbsolute |
| 1 |
| xlAbsRowRelColumn |
| 2 |
| xlRelative |
| 4 |
| xlRelRowAbsColumn |
| 3 |
xlRemoveDocInfoType |
| Specifies the type information to be removed from the document information. |
| xlRDIAll | Removes all documentation information (99) |
| xlRDIComments | Removes comments from the document information (1) |
| xlRDIContentType | Removes content type data from the document information (16) |
| xlRDIDefinedNameComments | Removes defined nameauthor="telias" time="20060816T160514-0800" data="s" comments from the documentation information (18) |
| xlRDIDocumentManagementPolicy | Removes document management policy data from the document information (15) |
| xlRDIDocumentProperties | Removes document properties from the document information (8) |
| xlRDIDocumentServerProperties | Removes server properties from the document information (14) |
| xlRDIDocumentWorkspace | Removes workspace data from the document information (10) |
| xlRDIEmailHeader | Removes email headers from the document information (5) |
| xlRDIExcelDataModel | (Added in 2013) (23) |
| xlRDIInactiveDataConnections | Removes inactive data connection data from the document information (19) |
| xlRDIInkAnnotations | Removes ink annotations from the document information (11) |
| xlRDIInlineWebExtensions | (Added in 2013) (21) |
| xlRDIPublishInfo | Removes the pubish information data from the document information (13) |
| xlRDIRemovePersonalInformation | Removes personal information from the document information (4) |
| xlRDIRoutingSlip | Removes routing slip information from the document information (6) |
| xlRDIScenarioComments | Removes scenario comments from the document information (12) |
| xlRDISendForReview | Removes the send for review information from the document information (7) |
| xlRDITaskPaneWebExtensions | (Added in 2013) (22) |
| xlRDIAll |
| Removes all documentation information (99) |
| xlRDIComments |
| Removes comments from the document information (1) |
| xlRDIContentType |
| Removes content type data from the document information (16) |
| xlRDIDefinedNameComments |
| Removes defined nameauthor="telias" time="20060816T160514-0800" data="s" comments from the documentation information (18) |
| xlRDIDocumentManagementPolicy |
| Removes document management policy data from the document information (15) |
| xlRDIDocumentProperties |
| Removes document properties from the document information (8) |
| xlRDIDocumentServerProperties |
| Removes server properties from the document information (14) |
| xlRDIDocumentWorkspace |
| Removes workspace data from the document information (10) |
| xlRDIEmailHeader |
| Removes email headers from the document information (5) |
| xlRDIExcelDataModel |
| (Added in 2013) (23) |
| xlRDIInactiveDataConnections |
| Removes inactive data connection data from the document information (19) |
| xlRDIInkAnnotations |
| Removes ink annotations from the document information (11) |
| xlRDIInlineWebExtensions |
| (Added in 2013) (21) |
| xlRDIPublishInfo |
| Removes the pubish information data from the document information (13) |
| xlRDIRemovePersonalInformation |
| Removes personal information from the document information (4) |
| xlRDIRoutingSlip |
| Removes routing slip information from the document information (6) |
| xlRDIScenarioComments |
| Removes scenario comments from the document information (12) |
| xlRDISendForReview |
| Removes the send for review information from the document information (7) |
| xlRDITaskPaneWebExtensions |
| (Added in 2013) (22) |
| REMARKS |
| * Added in 2007. |
xlRoutingSlipDelivery |
| Specifies the routing delivery method. |
| xlAllAtOnce | 2 |
| xlOneAfterAnother | 1 |
| xlAllAtOnce |
| 2 |
| xlOneAfterAnother |
| 1 |
xlRoutingSlipStatus |
| Specifies the status of the routing slip. |
| xlNotYetRouted | 0 |
| xlRoutingComplete | 2 |
| xlRoutingInProgress | 1 |
| xlNotYetRouted |
| 0 |
| xlRoutingComplete |
| 2 |
| xlRoutingInProgress |
| 1 |
xlRunAutoMacro |
| Specifies the automatic macro to run. |
| xlAutoActivate | Auto_Activate event (3) |
| xlAutoClose | Auto_Close event (2) |
| xlAutoDeactivate | Auto_Deactivate event (4) |
| xlAutoOpen | Auto_Open event (1) |
| xlAutoActivate |
| Auto_Activate event (3) |
| xlAutoClose |
| Auto_Close event (2) |
| xlAutoDeactivate |
| Auto_Deactivate event (4) |
| xlAutoOpen |
| Auto_Open event (1) |
xlSaveAction |
| Specifies during file close if the file will be saved. |
| xlDoNotSaveChanges | 2 |
| xlSaveChanges | 1 |
| xlDoNotSaveChanges |
| 2 |
| xlSaveChanges |
| 1 |
xlSaveAsAccessMode |
| Specifies the access mode for the save as function. |
| xlExclusive | Exclusive mode (3) |
| xlNoChange | Don't change the access mode (1) |
| xlShared | Share list (2) |
| xlExclusive |
| Exclusive mode (3) |
| xlNoChange |
| Don't change the access mode (1) |
| xlShared |
| Share list (2) |
xlSaveConflictResolution |
| Specifies the way conflicts are to be resolved whenever a shared workbook is updated. |
| xlLocalSessionChanges | Automatically accept the local user's changes (2) |
| xlOtherSessionChanges | Accept other changes instead of the local user's changes (3) |
| xlUserResolution | Display the conflict-resolution dialog box (1) |
| xlLocalSessionChanges |
| Automatically accept the local user's changes (2) |
| xlOtherSessionChanges |
| Accept other changes instead of the local user's changes (3) |
| xlUserResolution |
| Display the conflict-resolution dialog box (1) |
xlSearchDirection |
| Specifies the search direction when searching a range. |
| xlNext | Search for next matching value in range (1) |
| xlPrevious | Search for previous matching value in range (2) |
| xlNext |
| Search for next matching value in range (1) |
| xlPrevious |
| Search for previous matching value in range (2) |
xlSearchOrder |
| Specifies the order in which to search the range. |
| xlByColumns | Searches down through a column, then moves to the next column (2) |
| xlByRows | Searches across a row, then moves to the next row (1) |
| xlByColumns |
| Searches down through a column, then moves to the next column (2) |
| xlByRows |
| Searches across a row, then moves to the next row (1) |
xlSearchWithin |
| Specifies the extent of the search for the range. |
| xlWithinSheet | Limit search to current sheet (1) |
| xlWithinWorkbook | Search whole workbook (2) |
| xlWithinSheet |
| Limit search to current sheet (1) |
| xlWithinWorkbook |
| Search whole workbook (2) |
| REMARKS |
| * Added in 2002. |
xlSeriesColorGradientStyle |
| Specifies the colour gradient style for a series. |
| xlSeriesColorGradientStyleDiverging | 1 |
| xlSeriesColorGradientStyleSequential | 0 |
| xlSeriesColorGradientStyleDiverging |
| 1 |
| xlSeriesColorGradientStyleSequential |
| 0 |
| REMARKS |
| * Added in 2021. |
xlSeriesNameLevel |
| Specifies the series labels for the series label levels. |
| xlSeriesNameLevelAll | (default) Set series names to all series name levels within range on the chart (-1) |
| xlSeriesNameLevelCustom | Indicates literal data in the series name (-2) |
| xlSeriesNameLevelNone | Set no category labels in the chart and use automatic indexed labels (-3) |
| xlSeriesNameLevelAll |
| (default) Set series names to all series name levels within range on the chart (-1) |
| xlSeriesNameLevelCustom |
| Indicates literal data in the series name (-2) |
| xlSeriesNameLevelNone |
| Set no category labels in the chart and use automatic indexed labels (-3) |
| REMARKS |
| * Added in 2013. |
xlSizeRepresents |
| Specifies what the bubble size represents on a bubble chart. |
| xlSizeIsArea | Area of the bubble (1) |
| xlSizeIsWidth | Width of the bubble (2) |
| xlSizeIsArea |
| Area of the bubble (1) |
| xlSizeIsWidth |
| Width of the bubble (2) |
xlSlicerCacheType |
| Specifies the cache type to be used in the slicer. |
| xlSlicer | Slicer cache represents a slicer (1) |
| xlTimeline | Slicer cache represents a timeline (2) |
| xlSlicer |
| Slicer cache represents a slicer (1) |
| xlTimeline |
| Slicer cache represents a timeline (2) |
| REMARKS |
| * Added in 2013. |
xlSlicerCrossFilterType |
| Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
| xlSlicerNoCrossFilter | Cross filtering is turned off entirely, so all tiles are displayed and active (not dimmed) regardless of filtering selections in other slicers (1) |
| xlSlicerCrossFilterHideButtonsWithNoData | (Added in 2013) Cross filtering is turned on for this slicer cache, any tile with no data for filtering selection is other slicers connected to the same data source will be dimmed Additionally buttons will be hidden (4) |
| xlSlicerCrossFilterShowItemsWithDataAtTop | (Default) Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed Additionally, tiles with data are moved to the top in the slicer (2) |
| xlSlicerCrossFilterShowItemsWithNoData | Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed (3) |
| xlSlicerNoCrossFilter |
| Cross filtering is turned off entirely, so all tiles are displayed and active (not dimmed) regardless of filtering selections in other slicers (1) |
| xlSlicerCrossFilterHideButtonsWithNoData |
| (Added in 2013) Cross filtering is turned on for this slicer cache, any tile with no data for filtering selection is other slicers connected to the same data source will be dimmed Additionally buttons will be hidden (4) |
| xlSlicerCrossFilterShowItemsWithDataAtTop |
| (Default) Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed Additionally, tiles with data are moved to the top in the slicer (2) |
| xlSlicerCrossFilterShowItemsWithNoData |
| Cross filtering is turned on for this slicer cache, any tile with no data for a filtering selection in other slicers connected to the same data source will be dimmed (3) |
| REMARKS |
| * Added in 2010. |
xlSlicerSort |
| Specifies whether items displayed in the slicer are sorted. |
| xlSlicerSortAscending | Slicer items are sorted in ascending order by item captions (2) |
| xlSlicerSortDataSourceOrder | Slicer items are displayed in the order provided by the data source (1) |
| xlSlicerSortDescending | Slicer items are sorted in descending order by item captions (3) |
| xlSlicerSortAscending |
| Slicer items are sorted in ascending order by item captions (2) |
| xlSlicerSortDataSourceOrder |
| Slicer items are displayed in the order provided by the data source (1) |
| xlSlicerSortDescending |
| Slicer items are sorted in descending order by item captions (3) |
| REMARKS |
| * Added in 2010. |
xlSmartTagControlType |
| (Compatibility) Specifies the type of smart document control displayed in the document actions task pane. |
| xlSmartTagControlActiveX | 13 |
| xlSmartTagControlButton | 6 |
| xlSmartTagControlCheckbox | 9 |
| xlSmartTagControlCombo | 12 |
| xlSmartTagControlHelp | 3 |
| xlSmartTagControlHelpURL | 4 |
| xlSmartTagControlImage | 8 |
| xlSmartTagControlLabel | 7 |
| xlSmartTagControlLink | 2 |
| xlSmartTagControlListbox | 11 |
| xlSmartTagControlRadioGroup | 14 |
| xlSmartTagControlSeparator | 5 |
| xlSmartTagControlSmartTag | 1 |
| xlSmartTagControlTextbox | 10 |
| xlSmartTagControlActiveX |
| 13 |
| xlSmartTagControlButton |
| 6 |
| xlSmartTagControlCheckbox |
| 9 |
| xlSmartTagControlCombo |
| 12 |
| xlSmartTagControlHelp |
| 3 |
| xlSmartTagControlHelpURL |
| 4 |
| xlSmartTagControlImage |
| 8 |
| xlSmartTagControlLabel |
| 7 |
| xlSmartTagControlLink |
| 2 |
| xlSmartTagControlListbox |
| 11 |
| xlSmartTagControlRadioGroup |
| 14 |
| xlSmartTagControlSeparator |
| 5 |
| xlSmartTagControlSmartTag |
| 1 |
| xlSmartTagControlTextbox |
| 10 |
| REMARKS |
| * This enumeration is only available for backwards compatibility and should never be used. |
xlSmartTagDisplayMode |
| (Compatibility) Specifies the display features for smart tags. |
| xlButtonOnly | 2 |
| xlDisplayNone | 1 |
| xlIndicatorAndButton | 0 |
| xlButtonOnly |
| 2 |
| xlDisplayNone |
| 1 |
| xlIndicatorAndButton |
| 0 |
| REMARKS |
| * This enumeration is only available for backwards compatibility and should never be used. * Added in 2002. |
xlSortDataOption |
| Specifies how to sort text. |
| xlSortNormal | (Default) Sorts numeric and text data separately (0) |
| xlSortTextAsNumbers | Treat text as numeric data for the sort (1) |
| xlSortNormal |
| (Default) Sorts numeric and text data separately (0) |
| xlSortTextAsNumbers |
| Treat text as numeric data for the sort (1) |
| REMARKS |
| * Added in 2002. |
xlSortMethod |
| Specifies the type of sort. |
| xlPinYin | (Default) Phonetic Chinese sort order for characters This is the default value (1) |
| xlStroke | Sort by the quantity of strokes in each character (2) |
| xlPinYin |
| (Default) Phonetic Chinese sort order for characters This is the default value (1) |
| xlStroke |
| Sort by the quantity of strokes in each character (2) |
xlSortMethodOld |
| Specifies how to sort when using East Asian sorting methods. |
| xlCodePage | Sort by code page (2) |
| xlSyllabary | Sort phonetically (1) |
| xlCodePage |
| Sort by code page (2) |
| xlSyllabary |
| Sort phonetically (1) |
xlSortOn |
| Specifies the parameter on which the data should be sorted. |
| xlSortOnCellColor | Cell color (1) |
| xlSortOnFontColor | Font color (2) |
| xlSortOnIcon | Icon (3) |
| xlSortOnValues | Values (0) |
| xlSortOnCellColor |
| Cell color (1) |
| xlSortOnFontColor |
| Font color (2) |
| xlSortOnIcon |
| Icon (3) |
| xlSortOnValues |
| Values (0) |
| REMARKS |
| * Added in 2007. |
xlSortOrder |
| Specifies the sort order for the specified field or range. |
| xlAscending | (Default) Sorts the specified field in ascending order (1) |
| xlDescending | Sorts the specified field in descending order (2) |
| xlAscending |
| (Default) Sorts the specified field in ascending order (1) |
| xlDescending |
| Sorts the specified field in descending order (2) |
xlSortOrientation |
| Specifies the sort orientation. |
| xlSortColumns | Sorts by column (1) |
| xlSortRows | (Default) Sorts by row (2) |
| xlSortColumns |
| Sorts by column (1) |
| xlSortRows |
| (Default) Sorts by row (2) |
xlSortType |
| Specifies which elements are to be sorted in a pivottable report. |
| xlSortLabels | Sorts the PivotTable report by labels (2) |
| xlSortValues | Sorts the PivotTable report by values (1) |
| xlSortLabels |
| Sorts the PivotTable report by labels (2) |
| xlSortValues |
| Sorts the PivotTable report by values (1) |
xlSourceType |
| Specifies the type of source object. |
| xlSourceAutoFilter | An AutoFilter range (3) |
| xlSourceChart | A chart (5) |
| xlSourcePivotTable | A PivotTable report (6) |
| xlSourcePrintArea | A range of cells selected for printing (2) |
| xlSourceQuery | A query table (external data range) (7) |
| xlSourceRange | A range of cells (4) |
| xlSourceSheet | An entire worksheet (1) |
| xlSourceWorkbook | A workbook (0) |
| xlSourceAutoFilter |
| An AutoFilter range (3) |
| xlSourceChart |
| A chart (5) |
| xlSourcePivotTable |
| A PivotTable report (6) |
| xlSourcePrintArea |
| A range of cells selected for printing (2) |
| xlSourceQuery |
| A query table (external data range) (7) |
| xlSourceRange |
| A range of cells (4) |
| xlSourceSheet |
| An entire worksheet (1) |
| xlSourceWorkbook |
| A workbook (0) |
| REMARKS |
| * Added in 2000. |
xlSpanishModes |
| Specifies the mode for checking the spelling of Spanish. |
| xlSpanishTuteoAndVoseo | Tuteo and Voseo verb forms (1) |
| xlSpanishTuteoOnly | Tuteo verb forms only (0) |
| xlSpanishVoseoOnly | Voseo verb forms only (2) |
| xlSpanishTuteoAndVoseo |
| Tuteo and Voseo verb forms (1) |
| xlSpanishTuteoOnly |
| Tuteo verb forms only (0) |
| xlSpanishVoseoOnly |
| Voseo verb forms only (2) |
| REMARKS |
| * Added in 2010. |
xlSparklineRowCol |
| Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
| SparklineColumnsSquare | Plot the data by columns (2) |
| SparklineNonSquare | The sparkline is not bound to data in a square-shaped range (0) |
| SparklineRowsSquare | Plot the data by rows (1) |
| SparklineColumnsSquare |
| Plot the data by columns (2) |
| SparklineNonSquare |
| The sparkline is not bound to data in a square-shaped range (0) |
| SparklineRowsSquare |
| Plot the data by rows (1) |
| REMARKS |
| * Added in 2010. * The XlSparklineRowCol enumeration is used by the PlotBy property of the SparklineGroup object to determine how to plot chart in a sparkline when data on which it based is in a square-shaped range, such as A1:B2. |
xlSparkScale |
| Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
| xlSparkScaleCustom | The minimum or maximum value for the vertical axis of the sparkline has a user-defined value (3) |
| xlSparkScaleGroup | The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value (1) |
| xlSparkScaleSingle | The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value (2) |
| xlSparkScaleCustom |
| The minimum or maximum value for the vertical axis of the sparkline has a user-defined value (3) |
| xlSparkScaleGroup |
| The minimum or maximum value for the vertical axes of all of the sparklines in the group have the same value (1) |
| xlSparkScaleSingle |
| The minimum or maximum value for the vertical axis of each sparkline in the group is automatically set to its own calculated value (2) |
| REMARKS |
| * Added in 2010. * The constants of the XlSparkScale enumeration correspond to the settings of the Vertical Axis Minimum Value Options and the Vertical Axis Maximum Value Options on the Axis drop-down list on the Sparkline Tools Design tab of the ribbon. |
xlSparkType |
| Specifies the type of sparkline. |
| xlSparkLine | A line chart sparkline (1) |
| xlSparkColumn | A column chart sparkline (2) |
| xlSparkColumnStacked100 | A win/loss chart sparkline (3) |
| xlSparkLine |
| A line chart sparkline (1) |
| xlSparkColumn |
| A column chart sparkline (2) |
| xlSparkColumnStacked100 |
| A win/loss chart sparkline (3) |
| REMARKS |
| * Added in 2010. |
xlSpeakDirection |
| Specifies the order in which the cells are spoken. |
| xlSpeakByColumns | 1 |
| xlSpeakByRows | 0 |
| xlSpeakByColumns |
| 1 |
| xlSpeakByRows |
| 0 |
| REMARKS |
| * Added in 2002. |
xlSpecialCellsValue |
| Specifies cells with a particular type of value to include in the result. |
| xlErrors | 16 |
| xlLogical | 4 |
| xlNumbers | 1 |
| xlTextValues | 2 |
| xlErrors |
| 16 |
| xlLogical |
| 4 |
| xlNumbers |
| 1 |
| xlTextValues |
| 2 |
| REMARKS |
| * The xlErrors will find the following error types: #CALC!, #DIV/0, #FIELD!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #SPILL!, #VALUE!. |
xlSubscribeToFormat |
| Specifies the format to use when subscribing to a published edition. |
| xlSubscribeToPicture | -4147 |
| xlSubscribeToText | -4158 |
| xlSubscribeToPicture |
| -4147 |
| xlSubscribeToText |
| -4158 |
xlSubtotalLocationType |
| Specifies where the subtotal will be displayed on the worksheet. |
| xlAtBottom | 2 |
| xlAtTop | 1 |
| xlAtBottom |
| 2 |
| xlAtTop |
| 1 |
| REMARKS |
| * Added in 2000. |
xlSummaryColumn |
| Specifies the location of the summary columns in the outline. |
| xlSummaryOnLeft | -4131 |
| xlSummaryOnRight | -4152 |
| xlSummaryOnLeft |
| -4131 |
| xlSummaryOnRight |
| -4152 |
xlSummaryReportType |
| Specifies the location of the summary columns in the outline. |
| xlStandardSummary | 1 |
| xlSummaryPivotTable | -4148 |
| xlStandardSummary |
| 1 |
| xlSummaryPivotTable |
| -4148 |
xlSummaryRow |
| Specifies the location of the summary rows in the outline. |
| xlSummaryAbove | 0 |
| xlSummaryBelow | 1 |
| xlSummaryAbove |
| 0 |
| xlSummaryBelow |
| 1 |
xlTableStyleElementType |
| Specifies the table style element used. |
| xlBlankRow | Blank row (19) |
| xlColumnStripe1 | Column Stripe1 (7) |
| xlColumnStripe2 | Column Stripe2 (8) |
| xlColumnSubheading1 | Column Subheading1 (20) |
| xlColumnSubheading2 | Column Subheading2 (21) |
| xlColumnSubheading3 | Column Subheading3 (22) |
| xlFirstColumn | First column (3) |
| xlFirstHeaderCell | First header cell (9) |
| xlFirstTotalCell | First total cell (11) |
| xlGrandTotalColumn | Grand total column (4) |
| xlGrandTotalRow | Grand total row (2) |
| xlHeaderRow | Header row (1) |
| xlLastColumn | Last column (4) |
| xlLastHeaderCell | Last header cell (10) |
| xlLastTotalCell | Last total cell (12) |
| xlPageFieldLabels | Page field labels (26) |
| xlPageFieldValues | Page field values (27) |
| xlRowStripe1 | Row Stripe1 (5) |
| xlRowStripe2 | Row Stripe2 (6) |
| xlRowSubheading1 | Row Subheading1 (23) |
| xlRowSubheading2 | Row Subheading2 (24) |
| xlRowSubheading3 | Row Subheading3 (25) |
| xlSlicerHoveredSelectedItemWithData | (Added in 2010) (33) |
| xlSlicerHoveredSelectedItemWithNoData | (Added in 2010) (35) |
| xlSlicerHoveredUnselectedWithData | (Added in 2010) (32) |
| xlSlicerHoveredUnselectedWithNoData | (Added in 2010) (34) |
| xlSlicerSelectedWithData | (Added in 2010) (30) |
| xlSlicerSelectedWithNoData | (Added in 2010) (31) |
| xlSlicerUnselectedItemWithData | (Added in 2010) (28) |
| xlSlicerUnselectedItemWithNoData | (Added in 2010) (29) |
| xlSubtotalColumn1 | Subtotal Column1 (13) |
| xlSubtotalColumn2 | Subtotal Column2 (14) |
| xlSubtotalColumn3 | Subtotal Column3 (15) |
| xlSubtotalRow1 | Subtotal Row1 (16) |
| xlSubtotalRow2 | Subtotal Row2 (17) |
| xlSubtotalRow3 | Subtotal Row3 (18) |
| xlTimelinePeriodLabels1 | (Added in 2013) (38) |
| xlTimelinePeriodLabels2 | (Added in 2013) (39) |
| xlTimelineSelectedTimeBlock | (Added in 2013) (40) |
| xlTimelineSelectedTimeBlockSpace | (Added in 2013) (36) |
| xlTimelineSelectionLabel | (Added in 2013) (37) |
| xlTimelineTimeLevel | (Added in 2013) (41) |
| xlTimelineUnselectedTimeBlock | (Added in 2013) (42) |
| xlTotalRow | Total Row (2) |
| xlWholeTable | Whole Table (0) |
| xlBlankRow |
| Blank row (19) |
| xlColumnStripe1 |
| Column Stripe1 (7) |
| xlColumnStripe2 |
| Column Stripe2 (8) |
| xlColumnSubheading1 |
| Column Subheading1 (20) |
| xlColumnSubheading2 |
| Column Subheading2 (21) |
| xlColumnSubheading3 |
| Column Subheading3 (22) |
| xlFirstColumn |
| First column (3) |
| xlFirstHeaderCell |
| First header cell (9) |
| xlFirstTotalCell |
| First total cell (11) |
| xlGrandTotalColumn |
| Grand total column (4) |
| xlGrandTotalRow |
| Grand total row (2) |
| xlHeaderRow |
| Header row (1) |
| xlLastColumn |
| Last column (4) |
| xlLastHeaderCell |
| Last header cell (10) |
| xlLastTotalCell |
| Last total cell (12) |
| xlPageFieldLabels |
| Page field labels (26) |
| xlPageFieldValues |
| Page field values (27) |
| xlRowStripe1 |
| Row Stripe1 (5) |
| xlRowStripe2 |
| Row Stripe2 (6) |
| xlRowSubheading1 |
| Row Subheading1 (23) |
| xlRowSubheading2 |
| Row Subheading2 (24) |
| xlRowSubheading3 |
| Row Subheading3 (25) |
| xlSlicerHoveredSelectedItemWithData |
| (Added in 2010) (33) |
| xlSlicerHoveredSelectedItemWithNoData |
| (Added in 2010) (35) |
| xlSlicerHoveredUnselectedWithData |
| (Added in 2010) (32) |
| xlSlicerHoveredUnselectedWithNoData |
| (Added in 2010) (34) |
| xlSlicerSelectedWithData |
| (Added in 2010) (30) |
| xlSlicerSelectedWithNoData |
| (Added in 2010) (31) |
| xlSlicerUnselectedItemWithData |
| (Added in 2010) (28) |
| xlSlicerUnselectedItemWithNoData |
| (Added in 2010) (29) |
| xlSubtotalColumn1 |
| Subtotal Column1 (13) |
| xlSubtotalColumn2 |
| Subtotal Column2 (14) |
| xlSubtotalColumn3 |
| Subtotal Column3 (15) |
| xlSubtotalRow1 |
| Subtotal Row1 (16) |
| xlSubtotalRow2 |
| Subtotal Row2 (17) |
| xlSubtotalRow3 |
| Subtotal Row3 (18) |
| xlTimelinePeriodLabels1 |
| (Added in 2013) (38) |
| xlTimelinePeriodLabels2 |
| (Added in 2013) (39) |
| xlTimelineSelectedTimeBlock |
| (Added in 2013) (40) |
| xlTimelineSelectedTimeBlockSpace |
| (Added in 2013) (36) |
| xlTimelineSelectionLabel |
| (Added in 2013) (37) |
| xlTimelineTimeLevel |
| (Added in 2013) (41) |
| xlTimelineUnselectedTimeBlock |
| (Added in 2013) (42) |
| xlTotalRow |
| Total Row (2) |
| xlWholeTable |
| Whole Table (0) |
| REMARKS |
| * Added in 2007. |
xlTabPosition |
| Specifies the first or last tab position. |
| xlTabPositionFirst | 0 |
| xlTabPositionLast | 1 |
| xlTabPositionFirst |
| 0 |
| xlTabPositionLast |
| 1 |
xlTextParsingType |
| Specifies the column format for the data in the text file that you are importing into a query table. |
| xlDelimited* | 1 |
| xlFixedWidth | 2 |
| xlDelimited* |
| 1 |
| xlFixedWidth |
| 2 |
xlTextQualifier |
| Specifies the delimiter to use to specify text. |
| xlTextQualifierDoubleQuote* | 1 |
| xlTextQualifierNone | -4142 |
| xlTextQualifierSingleQuote | 2 |
| xlTextQualifierDoubleQuote* |
| 1 |
| xlTextQualifierNone |
| -4142 |
| xlTextQualifierSingleQuote |
| 2 |
xlTextVisualLayoutType |
| Specifies whether the visual layout of the text being imported is left-to-right or right-to-left. |
| xlTextVisualLTR | 1 |
| xlTextVisualRTL | 2 |
| xlTextVisualLTR |
| 1 |
| xlTextVisualRTL |
| 2 |
xlTimelineLevel |
| Specifies the time line to be used in the slicer. |
| xlTimelineLevelDays | Days level (3) |
| xlTimelineLevelMonths | Months level (2) |
| xlTimelineLevelQuarters | Quarters level (1) |
| xlTimelineLevelYears | Years level (0) |
| xlTimelineLevelDays |
| Days level (3) |
| xlTimelineLevelMonths |
| Months level (2) |
| xlTimelineLevelQuarters |
| Quarters level (1) |
| xlTimelineLevelYears |
| Years level (0) |
| REMARKS |
| * Added in 2013. |
xlTimeMoving |
| Specifies the period of time moving. (Removed in 2016) |
| xlTimeMovingDaily | (5) |
| xlTimeMovingMonthly | (3) |
| xlTimeMovingQuarterly | (2) |
| xlTimeMovingWeekly | (4) |
| xlTimeMovingYearly | (1) |
| xlTimeMovingYTD | (6) |
| xlTimeNotMoving | (0) |
| xlTimeMovingDaily |
| (5) |
| xlTimeMovingMonthly |
| (3) |
| xlTimeMovingQuarterly |
| (2) |
| xlTimeMovingWeekly |
| (4) |
| xlTimeMovingYearly |
| (1) |
| xlTimeMovingYTD |
| (6) |
| xlTimeNotMoving |
| (0) |
| REMARKS |
| * Added in 2013, Removed in 2016. * Does not appear in the 2013 visual basic editor object browser. |
xlTimePeriods |
| Specifies the time period. |
| xlLast7Days | Last 7 days (2) |
| xlLastMonth | Last month (5) |
| xlLastWeek | Last week (4) |
| xlNextMonth | Next month (8) |
| xlNextWeek | Next week (7) |
| xlThisMonth | This month (9) |
| xlThisWeek | This week (3) |
| xlToday | Today (0) |
| xlTomorrow | Tomorrow (6) |
| xlYesterday | Yesterday (1) |
| xlLast7Days |
| Last 7 days (2) |
| xlLastMonth |
| Last month (5) |
| xlLastWeek |
| Last week (4) |
| xlNextMonth |
| Next month (8) |
| xlNextWeek |
| Next week (7) |
| xlThisMonth |
| This month (9) |
| xlThisWeek |
| This week (3) |
| xlToday |
| Today (0) |
| xlTomorrow |
| Tomorrow (6) |
| xlYesterday |
| Yesterday (1) |
| REMARKS |
| * Added in 2007. |
xlToolbarProtection |
| Specifies which properties of a toolbar are restricted. |
| xlNoButtonChanges | 1 |
| xlNoChanges | 4 |
| xlNoDockingChanges | 3 |
| xlNoShapeChanges | 2 |
| xlToolbarProtectionNone | -4143 |
| xlNoButtonChanges |
| 1 |
| xlNoChanges |
| 4 |
| xlNoDockingChanges |
| 3 |
| xlNoShapeChanges |
| 2 |
| xlToolbarProtectionNone |
| -4143 |
xlTopBottom |
| Specifies the top 10 values from the top or bottom of a series of values. |
| xlTop10Bottom | Top 10 bottom values (0) |
| xlTop10Top | Top 10 values (1) |
| xlTop10Bottom |
| Top 10 bottom values (0) |
| xlTop10Top |
| Top 10 values (1) |
| REMARKS |
| * Added in 2007. |
xlTotalsCalculation |
| Specifies the type of calculation in the Totals row of a list column. |
| xlTotalsCalculationAverage | 2 |
| xlTotalsCalculationCount | 3 |
| xlTotalsCalculationCountNums | 4 |
| xlTotalsCalculationMax | 6 |
| xlTotalsCalculationMin | 5 |
| xlTotalsCalculationNone | 0 |
| xlTotalsCalculationStdDev | 7 |
| xlTotalsCalculationSum | 1 |
| xlTotalsCalculationVar | 8 |
| xlTotalsCalculationCustom | (Added in 2007) |
| xlTotalsCalculationAverage |
| 2 |
| xlTotalsCalculationCount |
| 3 |
| xlTotalsCalculationCountNums |
| 4 |
| xlTotalsCalculationMax |
| 6 |
| xlTotalsCalculationMin |
| 5 |
| xlTotalsCalculationNone |
| 0 |
| xlTotalsCalculationStdDev |
| 7 |
| xlTotalsCalculationSum |
| 1 |
| xlTotalsCalculationVar |
| 8 |
| xlTotalsCalculationCustom |
| (Added in 2007) |
xlValueSortOrder |
| Specifies the sort order for the values. |
| xlValueAscending | (1) |
| xlValueDescending | (2) |
| xlValueNone | (0) |
| xlValueAscending |
| (1) |
| xlValueDescending |
| (2) |
| xlValueNone |
| (0) |
| REMARKS |
| * Added in 2019. |
xlWebFormatting |
| Specifies how much formatting from a web page is applied when a web page is imported into a query table. |
| xlWebFormattingAll | 1 |
| xlWebFormattingNone | 3 |
| xlWebFormattingRTF | 2 |
| xlWebFormattingAll |
| 1 |
| xlWebFormattingNone |
| 3 |
| xlWebFormattingRTF |
| 2 |
| REMARKS |
| * Added in 2000. |
xlWebSelectionType |
| Specifies whether all the table(s) on an entire web page is imported into a query table. |
| xlAllTables | 2 |
| xlEntirePage | 1 |
| xlSpecifiedTables | 3 |
| xlAllTables |
| 2 |
| xlEntirePage |
| 1 |
| xlSpecifiedTables |
| 3 |
| REMARKS |
| * Added in 2000. |
xlXLMMacroType |
| Specifies what type of macro a name refers to or whether the name refers to a macro. |
| xlCommand | Custom command (2) |
| xlFunction | Custom function (1) |
| xlNotXLM | Not a macro (3) |
| xlCommand |
| Custom command (2) |
| xlFunction |
| Custom function (1) |
| xlNotXLM |
| Not a macro (3) |
xlXmlExportResult |
| Specifies the results of the save or export operation. |
| xlXmlExportSuccess | The XML data file was successfully exported (0) |
| xlXmlExportValidationFailed | The contents of the XML data file do not match the specified schema map (1) |
| xlXmlExportSuccess |
| The XML data file was successfully exported (0) |
| xlXmlExportValidationFailed |
| The contents of the XML data file do not match the specified schema map (1) |
xlXmlImportResult |
| Specifies whether or not the first row contains headers. |
| xlXmlImportElementsTruncated | The contents of the specified XML data file have been truncated because the XML data file is too large for the worksheet (1) |
| xlXmlImportSuccess | The XML data file was successfully imported (0) |
| xlXmlImportValidationFailed | The contents of the XML data file do not match the specified schema map (2) |
| xlXmlImportElementsTruncated |
| The contents of the specified XML data file have been truncated because the XML data file is too large for the worksheet (1) |
| xlXmlImportSuccess |
| The XML data file was successfully imported (0) |
| xlXmlImportValidationFailed |
| The contents of the XML data file do not match the specified schema map (2) |
xlXmlLoadOption |
| Specifies how Excel opens the XML data file. |
| xlXmlLoadImportToList | Places the contents of the XML data file in an XML table (2) |
| xlXmlLoadMapXml | Displays the schema of the XML data file in the XML Structure task pane (3) |
| xlXmlLoadOpenXml | Opens the XML data file The contents of the file will be flattened (1) |
| xlXmlLoadPromptUser | Prompts the user to choose how to open the file (0) |
| xlXmlLoadImportToList |
| Places the contents of the XML data file in an XML table (2) |
| xlXmlLoadMapXml |
| Displays the schema of the XML data file in the XML Structure task pane (3) |
| xlXmlLoadOpenXml |
| Opens the XML data file The contents of the file will be flattened (1) |
| xlXmlLoadPromptUser |
| Prompts the user to choose how to open the file (0) |
xlYesNoGuess |
| Specifies whether or not the first row contains headers. |
| xlGuess | Excel determines whether there is a header, and where it is, if there is one (0) |
| xlNo | Default The entire range should be sorted (2) |
| xlYes | The entire range should not be sorted (1) |
| xlGuess |
| Excel determines whether there is a header, and where it is, if there is one (0) |
| xlNo |
| Default The entire range should be sorted (2) |
| xlYes |
| The entire range should not be sorted (1) |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top