Show All
Microsoft Excel Constants
This topic lists all constants in the Microsoft Excel object model.
XlApplicationInternational
Constant |
Value |
xl24HourClock |
33 |
xl4DigitYears |
43 |
xlAlternateArraySeparator |
16 |
xlColumnSeparator |
14 |
xlCountryCode |
1 |
xlCountrySetting |
2 |
xlCurrencyBefore |
37 |
xlCurrencyCode |
25 |
xlCurrencyDigits |
27 |
xlCurrencyLeadingZeros |
40 |
xlCurrencyMinusSign |
38 |
xlCurrencyNegative |
28 |
xlCurrencySpaceBefore |
36 |
xlCurrencyTrailingZeros |
39 |
xlDateOrder |
32 |
xlDateSeparator |
17 |
xlDayCode |
21 |
xlDayLeadingZero |
42 |
xlDecimalSeparator |
3 |
xlGeneralFormatName |
26 |
xlHourCode |
22 |
xlLeftBrace |
12 |
xlLeftBracket |
10 |
xlListSeparator |
5 |
xlLowerCaseColumnLetter |
9 |
xlLowerCaseRowLetter |
8 |
xlMDY |
44 |
xlMetric |
35 |
xlMinuteCode |
23 |
xlMonthCode |
20 |
xlMonthLeadingZero |
41 |
xlMonthNameChars |
30 |
xlNoncurrencyDigits |
29 |
xlNonEnglishFunctions |
34 |
xlRightBrace |
13 |
xlRightBracket |
11 |
xlRowSeparator |
15 |
xlSecondCode |
24 |
xlThousandsSeparator |
4 |
xlTimeLeadingZero |
45 |
xlTimeSeparator |
18 |
xlUpperCaseColumnLetter |
7 |
xlUpperCaseRowLetter |
6 |
xlWeekdayNameChars |
31 |
xlYearCode |
19 |
XlApplyNamesOrder
Constant |
Value |
xlColumnThenRow |
2 |
xlRowThenColumn |
1 |
XlArabicModes
Constant |
Value |
xlArabicBothStrict |
3 |
xlArabicNone |
0 |
xlArabicStrictAlefHamza |
1 |
xlArabicStrictFinalYaa |
2 |
XlArrangeStyle
Constant |
Value |
xlArrangeStyleCascade |
7 |
xlArrangeStyleHorizontal |
-4128 |
xlArrangeStyleTiled |
1 |
xlArrangeStyleVertical |
-4166 |
XlArrowHeadLength
Constant |
Value |
xlArrowHeadLengthLong |
3 |
xlArrowHeadLengthMedium |
-4138 |
xlArrowHeadLengthShort |
1 |
XlArrowHeadStyle
Constant |
Value |
xlArrowHeadStyleClosed |
3 |
xlArrowHeadStyleDoubleClosed |
5 |
xlArrowHeadStyleDoubleOpen |
4 |
xlArrowHeadStyleNone |
-4142 |
xlArrowHeadStyleOpen |
2 |
XlArrowHeadWidth
Constant |
Value |
xlArrowHeadWidthMedium |
-4138 |
xlArrowHeadWidthNarrow |
1 |
xlArrowHeadWidthWide |
3 |
XlAutoFillType
Constant |
Value |
xlFillCopy |
1 |
xlFillDays |
5 |
xlFillDefault |
0 |
xlFillFormats |
3 |
xlFillMonths |
7 |
xlFillSeries |
2 |
xlFillValues |
4 |
xlFillWeekdays |
6 |
xlFillYears |
8 |
xlGrowthTrend |
10 |
xlLinearTrend |
9 |
XlAutoFilterOperator
Constant |
Value |
xlAnd |
1 |
xlBottom10Items |
4 |
xlBottom10Percent |
6 |
xlOr |
2 |
xlTop10Items |
3 |
xlTop10Percent |
5 |
XlAxisCrosses
Constant |
Value |
xlAxisCrossesAutomatic |
-4105 |
xlAxisCrossesCustom |
-4114 |
xlAxisCrossesMaximum |
2 |
xlAxisCrossesMinimum |
4 |
XlAxisGroup
Constant |
Value |
xlPrimary |
1 |
xlSecondary |
2 |
XlAxisType
Constant |
Value |
xlCategory |
1 |
xlSeriesAxis |
3 |
xlValue |
2 |
XlBackground
Constant |
Value |
xlBackgroundAutomatic |
-4105 |
xlBackgroundOpaque |
3 |
xlBackgroundTransparent |
2 |
XlBarShape
Constant |
Value |
xlBox |
0 |
xlConeToMax |
5 |
xlConeToPoint |
4 |
xlCylinder |
3 |
xlPyramidToMax |
2 |
xlPyramidToPoint |
1 |
XlBordersIndex
Constant |
Value |
xlDiagonalDown |
5 |
xlDiagonalUp |
6 |
xlEdgeBottom |
9 |
xlEdgeLeft |
7 |
xlEdgeRight |
10 |
xlEdgeTop |
8 |
xlInsideHorizontal |
12 |
xlInsideVertical |
11 |
XlBorderWeight
Constant |
Value |
xlHairline |
1 |
xlMedium |
-4138 |
xlThick |
4 |
xlThin |
2 |
XlBuiltInDialog
Constant |
Value |
_xlDialogChartSourceData |
541 |
_xlDialogPhonetic |
538 |
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 |
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 |
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 |
xlDialogMenuEditor |
322 |
xlDialogMove |
262 |
xlDialogMyPermission |
834 |
xlDialogNew |
119 |
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 |
xlDialogPivotTableWizard |
312 |
xlDialogPlacement |
300 |
xlDialogPrint |
8 |
xlDialogPrinterSetup |
9 |
xlDialogPrintPreview |
222 |
xlDialogPromote |
202 |
xlDialogProperties |
474 |
xlDialogPropertyFields |
754 |
xlDialogProtectDocument |
28 |
xlDialogProtectSharing |
620 |
xlDialogPublishAsWebPage |
653 |
xlDialogPushbuttonProperties |
445 |
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 |
xlDialogSetPrintTitles |
23 |
xlDialogSetUpdateStatus |
159 |
xlDialogShowDetail |
204 |
xlDialogShowToolbar |
220 |
xlDialogSize |
261 |
xlDialogSort |
39 |
xlDialogSortSpecial |
192 |
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 |
XlCalculatedMemberType
Constant |
Value |
xlCalculatedMember |
0 |
xlCalculatedSet |
1 |
XlCalculation
Constant |
Value |
xlCalculationAutomatic |
-4105 |
xlCalculationManual |
-4135 |
xlCalculationSemiautomatic |
2 |
XlCalculationInterruptKey
Constant |
Value |
xlAnyKey |
2 |
xlEscKey |
1 |
xlNoKey |
0 |
XlCalculationState
Constant |
Value |
xlCalculating |
1 |
xlDone |
0 |
xlPending |
2 |
XlCategoryType
Constant |
Value |
xlAutomaticScale |
-4105 |
xlCategoryScale |
2 |
xlTimeScale |
3 |
XlCellInsertionMode
Constant |
Value |
xlInsertDeleteCells |
1 |
xlInsertEntireRows |
2 |
xlOverwriteCells |
0 |
XlCellType
Constant |
Value |
xlCellTypeAllFormatConditions |
-4172 |
xlCellTypeAllValidation |
-4174 |
xlCellTypeBlanks |
4 |
xlCellTypeComments |
-4144 |
xlCellTypeConstants |
2 |
xlCellTypeFormulas |
-4123 |
xlCellTypeLastCell |
11 |
xlCellTypeSameFormatConditions |
-4173 |
xlCellTypeSameValidation |
-4175 |
xlCellTypeVisible |
12 |
XlChartGallery
Constant |
Value |
xlAnyGallery |
23 |
xlBuiltIn |
21 |
xlUserDefined |
22 |
XlChartItem
Constant |
Value |
xlAxis |
21 |
xlAxisTitle |
17 |
xlChartArea |
2 |
xlChartTitle |
4 |
xlCorners |
6 |
xlDataLabel |
0 |
xlDataTable |
7 |
xlDisplayUnitLabel |
30 |
xlDownBars |
20 |
xlDropLines |
26 |
xlErrorBars |
9 |
xlFloor |
23 |
xlHiLoLines |
25 |
xlLeaderLines |
29 |
xlLegend |
24 |
xlLegendEntry |
12 |
xlLegendKey |
13 |
xlMajorGridlines |
15 |
xlMinorGridlines |
16 |
xlNothing |
28 |
xlPivotChartDropZone |
32 |
xlPivotChartFieldButton |
31 |
xlPlotArea |
19 |
xlRadarAxisLabels |
27 |
xlSeries |
3 |
xlSeriesLines |
22 |
xlShape |
14 |
xlTrendline |
8 |
xlUpBars |
18 |
xlWalls |
5 |
xlXErrorBars |
10 |
xlYErrorBars |
11 |
XlChartLocation
Constant |
Value |
xlLocationAsNewSheet |
1 |
xlLocationAsObject |
2 |
xlLocationAutomatic |
3 |
XlChartPicturePlacement
Constant |
Value |
xlAllFaces |
7 |
xlEnd |
2 |
xlEndSides |
3 |
xlFront |
4 |
xlFrontEnd |
6 |
xlFrontSides |
5 |
xlSides |
1 |
XlChartPictureType
Constant |
Value |
xlStack |
2 |
xlStackScale |
3 |
xlStretch |
1 |
XlChartSplitType
Constant |
Value |
xlSplitByCustomSplit |
4 |
xlSplitByPercentValue |
3 |
xlSplitByPosition |
1 |
xlSplitByValue |
2 |
XlChartType
Constant |
Value |
xl3DArea |
-4098 |
xl3DAreaStacked |
78 |
xl3DAreaStacked100 |
79 |
xl3DBarClustered |
60 |
xl3DBarStacked |
61 |
xl3DBarStacked100 |
62 |
xl3DColumn |
-4100 |
xl3DColumnClustered |
54 |
xl3DColumnStacked |
55 |
xl3DColumnStacked100 |
56 |
xl3DLine |
-4101 |
xl3DPie |
-4102 |
xl3DPieExploded |
70 |
xlArea |
1 |
xlAreaStacked |
76 |
xlAreaStacked100 |
77 |
xlBarClustered |
57 |
xlBarOfPie |
71 |
xlBarStacked |
58 |
xlBarStacked100 |
59 |
xlBubble |
15 |
xlBubble3DEffect |
87 |
xlColumnClustered |
51 |
xlColumnStacked |
52 |
xlColumnStacked100 |
53 |
xlConeBarClustered |
102 |
xlConeBarStacked |
103 |
xlConeBarStacked100 |
104 |
xlConeCol |
105 |
xlConeColClustered |
99 |
xlConeColStacked |
100 |
xlConeColStacked100 |
101 |
xlCylinderBarClustered |
95 |
xlCylinderBarStacked |
96 |
xlCylinderBarStacked100 |
97 |
xlCylinderCol |
98 |
xlCylinderColClustered |
92 |
xlCylinderColStacked |
93 |
xlCylinderColStacked100 |
94 |
xlDoughnut |
-4120 |
xlDoughnutExploded |
80 |
xlLine |
4 |
xlLineMarkers |
65 |
xlLineMarkersStacked |
66 |
xlLineMarkersStacked100 |
67 |
xlLineStacked |
63 |
xlLineStacked100 |
64 |
xlPie |
5 |
xlPieExploded |
69 |
xlPieOfPie |
68 |
xlPyramidBarClustered |
109 |
xlPyramidBarStacked |
110 |
xlPyramidBarStacked100 |
111 |
xlPyramidCol |
112 |
xlPyramidColClustered |
106 |
xlPyramidColStacked |
107 |
xlPyramidColStacked100 |
108 |
xlRadar |
-4151 |
xlRadarFilled |
82 |
xlRadarMarkers |
81 |
xlStockHLC |
88 |
xlStockOHLC |
89 |
xlStockVHLC |
90 |
xlStockVOHLC |
91 |
xlSurface |
83 |
xlSurfaceTopView |
85 |
xlSurfaceTopViewWireframe |
86 |
xlSurfaceWireframe |
84 |
xlXYScatter |
-4169 |
xlXYScatterLines |
74 |
xlXYScatterLinesNoMarkers |
75 |
xlXYScatterSmooth |
72 |
xlXYScatterSmoothNoMarkers |
73 |
XlClipboardFormat
Constant |
Value |
xlClipboardFormatBIFF |
8 |
xlClipboardFormatBIFF2 |
18 |
xlClipboardFormatBIFF3 |
20 |
xlClipboardFormatBIFF4 |
30 |
xlClipboardFormatBinary |
15 |
xlClipboardFormatBitmap |
9 |
xlClipboardFormatCGM |
13 |
xlClipboardFormatCSV |
5 |
xlClipboardFormatDIF |
4 |
xlClipboardFormatDspText |
12 |
xlClipboardFormatEmbeddedObject |
21 |
xlClipboardFormatEmbedSource |
22 |
xlClipboardFormatLink |
11 |
xlClipboardFormatLinkSource |
23 |
xlClipboardFormatLinkSourceDesc |
32 |
xlClipboardFormatMovie |
24 |
xlClipboardFormatNative |
14 |
xlClipboardFormatObjectDesc |
31 |
xlClipboardFormatObjectLink |
19 |
xlClipboardFormatOwnerLink |
17 |
xlClipboardFormatPICT |
2 |
xlClipboardFormatPrintPICT |
3 |
xlClipboardFormatRTF |
7 |
xlClipboardFormatScreenPICT |
29 |
xlClipboardFormatStandardFont |
28 |
xlClipboardFormatStandardScale |
27 |
xlClipboardFormatSYLK |
6 |
xlClipboardFormatTable |
16 |
xlClipboardFormatText |
0 |
xlClipboardFormatToolFace |
25 |
xlClipboardFormatToolFacePICT |
26 |
xlClipboardFormatVALU |
1 |
xlClipboardFormatWK1 |
10 |
XlCmdType
Constant |
Value |
xlCmdCube |
1 |
xlCmdDefault |
4 |
xlCmdList |
5 |
xlCmdSql |
2 |
xlCmdTable |
3 |
XlColorIndex
Constant |
Value |
xlColorIndexAutomatic |
-4105 |
xlColorIndexNone |
-4142 |
XlColumnDataType
Constant |
Value |
xlDMYFormat |
4 |
xlDYMFormat |
7 |
xlEMDFormat |
10 |
xlGeneralFormat |
1 |
xlMDYFormat |
3 |
xlMYDFormat |
6 |
xlSkipColumn |
9 |
xlTextFormat |
2 |
xlYDMFormat |
8 |
xlYMDFormat |
5 |
XlCommandUnderlines
Constant |
Value |
xlCommandUnderlinesAutomatic |
-4105 |
xlCommandUnderlinesOff |
-4146 |
xlCommandUnderlinesOn |
1 |
XlCommentDisplayMode
Constant |
Value |
xlCommentAndIndicator |
1 |
xlCommentIndicatorOnly |
-1 |
xlNoIndicator |
0 |
XlConsolidationFunction
Constant |
Value |
xlAverage |
-4106 |
xlCount |
-4112 |
xlCountNums |
-4113 |
xlMax |
-4136 |
xlMin |
-4139 |
xlProduct |
-4149 |
xlStDev |
-4155 |
xlStDevP |
-4156 |
xlSum |
-4157 |
xlUnknown |
1000 |
xlVar |
-4164 |
xlVarP |
-4165 |
XlCopyPictureFormat
Constant |
Value |
xlBitmap |
2 |
xlPicture |
-4147 |
XlCorruptLoad
Constant |
Value |
xlExtractData |
2 |
xlNormalLoad |
0 |
xlRepairFile |
1 |
XlCreator
Constant |
Value |
xlCreatorCode |
1480803660 |
XlCubeFieldType
Constant |
Value |
xlHierarchy |
1 |
xlMeasure |
2 |
xlSet |
3 |
XlCutCopyMode
Constant |
Value |
xlCopy |
1 |
xlCut |
2 |
XlCVError
Constant |
Value |
xlErrDiv0 |
2007 |
xlErrNA |
2042 |
xlErrName |
2029 |
xlErrNull |
2000 |
xlErrNum |
2036 |
xlErrRef |
2023 |
xlErrValue |
2015 |
XlDataLabelPosition
Constant |
Value |
xlLabelPositionAbove |
0 |
xlLabelPositionBelow |
1 |
xlLabelPositionBestFit |
5 |
xlLabelPositionCenter |
-4108 |
xlLabelPositionCustom |
7 |
xlLabelPositionInsideBase |
4 |
xlLabelPositionInsideEnd |
3 |
xlLabelPositionLeft |
-4131 |
xlLabelPositionMixed |
6 |
xlLabelPositionOutsideEnd |
2 |
xlLabelPositionRight |
-4152 |
XlDataLabelSeparator
Constant |
Value |
xlDataLabelSeparatorDefault |
1 |
XlDataLabelsType
Constant |
Value |
xlDataLabelsShowBubbleSizes |
6 |
xlDataLabelsShowLabel |
4 |
xlDataLabelsShowLabelAndPercent |
5 |
xlDataLabelsShowNone |
-4142 |
xlDataLabelsShowPercent |
3 |
xlDataLabelsShowValue |
2 |
XlDataSeriesDate
Constant |
Value |
xlDay |
1 |
xlMonth |
3 |
xlWeekday |
2 |
xlYear |
4 |
XlDataSeriesType
Constant |
Value |
xlAutoFill |
4 |
xlChronological |
3 |
xlDataSeriesLinear |
-4132 |
xlGrowth |
2 |
XlDeleteShiftDirection
Constant |
Value |
xlShiftToLeft |
-4159 |
xlShiftUp |
-4162 |
XlDirection
Constant |
Value |
xlDown |
-4121 |
xlToLeft |
-4159 |
xlToRight |
-4161 |
xlUp |
-4162 |
XlDisplayBlanksAs
Constant |
Value |
xlInterpolated |
3 |
xlNotPlotted |
1 |
xlZero |
2 |
XlDisplayDrawingObjects
Constant |
Value |
xlDisplayShapes |
-4104 |
xlHide |
3 |
xlPlaceholders |
2 |
XlDisplayUnit
Constant |
Value |
xlHundredMillions |
-8 |
xlHundreds |
-2 |
xlHundredThousands |
-5 |
xlMillionMillions |
-10 |
xlMillions |
-6 |
xlTenMillions |
-7 |
xlTenThousands |
-4 |
xlThousandMillions |
-9 |
xlThousands |
-3 |
XlDVAlertStyle
Constant |
Value |
xlValidAlertInformation |
3 |
xlValidAlertStop |
1 |
xlValidAlertWarning |
2 |
XlDVType
Constant |
Value |
xlValidateCustom |
7 |
xlValidateDate |
4 |
xlValidateDecimal |
2 |
xlValidateInputOnly |
0 |
xlValidateList |
3 |
xlValidateTextLength |
6 |
xlValidateTime |
5 |
xlValidateWholeNumber |
1 |
XlEditionFormat
Constant |
Value |
xlBIFF |
2 |
xlPICT |
1 |
xlRTF |
4 |
xlVALU |
8 |
XlEditionOptionsOption
Constant |
Value |
xlAutomaticUpdate |
4 |
xlCancel |
1 |
xlChangeAttributes |
6 |
xlManualUpdate |
5 |
xlOpenSource |
3 |
xlSelect |
3 |
xlSendPublisher |
2 |
xlUpdateSubscriber |
2 |
XlEditionType
Constant |
Value |
xlPublisher |
1 |
xlSubscriber |
2 |
XlEnableCancelKey
Constant |
Value |
xlDisabled |
0 |
xlErrorHandler |
2 |
xlInterrupt |
1 |
XlEnableSelection
Constant |
Value |
xlNoRestrictions |
0 |
xlNoSelection |
-4142 |
xlUnlockedCells |
1 |
XlEndStyleCap
Constant |
Value |
xlCap |
1 |
xlNoCap |
2 |
XlErrorBarDirection
Constant |
Value |
xlX |
-4168 |
xlY |
1 |
XlErrorBarInclude
Constant |
Value |
xlErrorBarIncludeBoth |
1 |
xlErrorBarIncludeMinusValues |
3 |
xlErrorBarIncludeNone |
-4142 |
xlErrorBarIncludePlusValues |
2 |
XlErrorBarType
Constant |
Value |
xlErrorBarTypeCustom |
-4114 |
xlErrorBarTypeFixedValue |
1 |
xlErrorBarTypePercent |
2 |
xlErrorBarTypeStDev |
-4155 |
xlErrorBarTypeStError |
4 |
XlErrorChecks
Constant |
Value |
xlEmptyCellReferences |
7 |
xlEvaluateToError |
1 |
xlInconsistentFormula |
4 |
xlListDataValidation |
8 |
xlNumberAsText |
3 |
xlOmittedCells |
5 |
xlTextDate |
2 |
xlUnlockedFormulaCells |
6 |
XlFileAccess
Constant |
Value |
xlReadOnly |
3 |
xlReadWrite |
2 |
XlFileFormat
Constant |
Value |
xlAddIn |
18 |
xlCSV |
6 |
xlCSVMac |
22 |
xlCSVMSDOS |
24 |
xlCSVWindows |
23 |
xlCurrentPlatformText |
-4158 |
xlDBF2 |
7 |
xlDBF3 |
8 |
xlDBF4 |
11 |
xlDIF |
9 |
xlExcel2 |
16 |
xlExcel2FarEast |
27 |
xlExcel3 |
29 |
xlExcel4 |
33 |
xlExcel4Workbook |
35 |
xlExcel5 |
39 |
xlExcel7 |
39 |
xlExcel9795 |
43 |
xlHtml |
44 |
xlIntlAddIn |
26 |
xlIntlMacro |
25 |
xlSYLK |
2 |
xlTemplate |
17 |
xlTextMac |
19 |
xlTextMSDOS |
21 |
xlTextPrinter |
36 |
xlTextWindows |
20 |
xlUnicodeText |
42 |
xlWebArchive |
45 |
xlWJ2WD1 |
14 |
xlWJ3 |
40 |
xlWJ3FJ3 |
41 |
xlWK1 |
5 |
xlWK1ALL |
31 |
xlWK1FMT |
30 |
xlWK3 |
15 |
xlWK3FM3 |
32 |
xlWK4 |
38 |
xlWKS |
4 |
xlWorkbookNormal |
-4143 |
xlWorks2FarEast |
28 |
xlWQ1 |
34 |
xlXMLData |
47 |
xlXMLSpreadsheet |
46 |
XlFillWith
Constant |
Value |
xlFillWithAll |
-4104 |
xlFillWithContents |
2 |
xlFillWithFormats |
-4122 |
XlFilterAction
Constant |
Value |
xlFilterCopy |
2 |
xlFilterInPlace |
1 |
XlFindLookIn
Constant |
Value |
xlComments |
-4144 |
xlFormulas |
-4123 |
xlValues |
-4163 |
XlFormatConditionOperator
Constant |
Value |
xlBetween |
1 |
xlEqual |
3 |
xlGreater |
5 |
xlGreaterEqual |
7 |
xlLess |
6 |
xlLessEqual |
8 |
xlNotBetween |
2 |
xlNotEqual |
4 |
XlFormatConditionType
Constant |
Value |
xlCellValue |
1 |
xlExpression |
2 |
XlFormControl
Constant |
Value |
xlButtonControl |
0 |
xlCheckBox |
1 |
xlDropDown |
2 |
xlEditBox |
3 |
xlGroupBox |
4 |
xlLabel |
5 |
xlListBox |
6 |
xlOptionButton |
7 |
xlScrollBar |
8 |
xlSpinner |
9 |
XlFormulaLabel
Constant |
Value |
xlColumnLabels |
2 |
xlMixedLabels |
3 |
xlNoLabels |
-4142 |
xlRowLabels |
1 |
XlHAlign
Constant |
Value |
xlHAlignCenter |
-4108 |
xlHAlignCenterAcrossSelection |
7 |
xlHAlignDistributed |
-4117 |
xlHAlignFill |
5 |
xlHAlignGeneral |
1 |
xlHAlignJustify |
-4130 |
xlHAlignLeft |
-4131 |
xlHAlignRight |
-4152 |
XlHebrewModes
Constant |
Value |
xlHebrewFullScript |
0 |
xlHebrewMixedAuthorizedScript |
3 |
xlHebrewMixedScript |
2 |
xlHebrewPartialScript |
1 |
XlHighlightChangesTime
Constant |
Value |
xlAllChanges |
2 |
xlNotYetReviewed |
3 |
xlSinceMyLastSave |
1 |
XlHtmlType
Constant |
Value |
xlHtmlCalc |
1 |
xlHtmlChart |
3 |
xlHtmlList |
2 |
xlHtmlStatic |
0 |
XlIMEMode
Constant |
Value |
xlIMEModeAlpha |
8 |
xlIMEModeAlphaFull |
7 |
xlIMEModeDisable |
3 |
xlIMEModeHangul |
10 |
xlIMEModeHangulFull |
9 |
xlIMEModeHiragana |
4 |
xlIMEModeKatakana |
5 |
xlIMEModeKatakanaHalf |
6 |
xlIMEModeNoControl |
0 |
xlIMEModeOff |
2 |
xlIMEModeOn |
1 |
XlImportDataAs
Constant |
Value |
xlPivotTableReport |
1 |
xlQueryTable |
0 |
XlInsertFormatOrigin
Constant |
Value |
xlFormatFromLeftOrAbove |
0 |
xlFormatFromRightOrBelow |
1 |
XlInsertShiftDirection
Constant |
Value |
xlShiftDown |
-4121 |
xlShiftToRight |
-4161 |
XlLayoutFormType
Constant |
Value |
xlOutline |
1 |
xlTabular |
0 |
XlLegendPosition
Constant |
Value |
xlLegendPositionBottom |
-4107 |
xlLegendPositionCorner |
2 |
xlLegendPositionLeft |
-4131 |
xlLegendPositionRight |
-4152 |
xlLegendPositionTop |
-4160 |
XlLineStyle
Constant |
Value |
xlContinuous |
1 |
xlDash |
-4115 |
xlDashDot |
4 |
xlDashDotDot |
5 |
xlDot |
-4118 |
xlDouble |
-4119 |
xlLineStyleNone |
-4142 |
xlSlantDashDot |
13 |
XlLink
Constant |
Value |
xlExcelLinks |
1 |
xlOLELinks |
2 |
xlPublishers |
5 |
xlSubscribers |
6 |
XlLinkInfo
Constant |
Value |
xlEditionDate |
2 |
xlLinkInfoStatus |
3 |
xlUpdateState |
1 |
XlLinkInfoType
Constant |
Value |
xlLinkInfoOLELinks |
2 |
xlLinkInfoPublishers |
5 |
xlLinkInfoSubscribers |
6 |
XlLinkStatus
Constant |
Value |
xlLinkStatusCopiedValues |
10 |
xlLinkStatusIndeterminate |
5 |
xlLinkStatusInvalidName |
7 |
xlLinkStatusMissingFile |
1 |
xlLinkStatusMissingSheet |
2 |
xlLinkStatusNotStarted |
6 |
xlLinkStatusOK |
0 |
xlLinkStatusOld |
3 |
xlLinkStatusSourceNotCalculated |
4 |
xlLinkStatusSourceNotOpen |
8 |
xlLinkStatusSourceOpen |
9 |
XlLinkType
Constant |
Value |
xlLinkTypeExcelLinks |
1 |
xlLinkTypeOLELinks |
2 |
XlListConflict
Constant |
Value |
xlListConflictDialog |
0 |
xlListConflictDiscardAllConflicts |
2 |
xlListConflictError |
3 |
xlListConflictRetryAllConflicts |
1 |
XlListDataType
Constant |
Value |
xlListDataTypeCheckbox |
9 |
xlListDataTypeChoice |
6 |
xlListDataTypeChoiceMulti |
7 |
xlListDataTypeCounter |
11 |
xlListDataTypeCurrency |
4 |
xlListDataTypeDateTime |
5 |
xlListDataTypeHyperLink |
10 |
xlListDataTypeListLookup |
8 |
xlListDataTypeMultiLineRichText |
12 |
xlListDataTypeMultiLineText |
2 |
xlListDataTypeNone |
0 |
xlListDataTypeNumber |
3 |
xlListDataTypeText |
1 |
XlListObjectSourceType
Constant |
Value |
xlSrcExternal |
0 |
xlSrcRange |
1 |
xlSrcXml |
2 |
XlLocationInTable
Constant |
Value |
xlColumnHeader |
-4110 |
xlColumnItem |
5 |
xlDataHeader |
3 |
xlDataItem |
7 |
xlPageHeader |
2 |
xlPageItem |
6 |
xlRowHeader |
-4153 |
xlRowItem |
4 |
xlTableBody |
8 |
XlLookAt
Constant |
Value |
xlPart |
2 |
xlWhole |
1 |
XlMailSystem
Constant |
Value |
xlMAPI |
1 |
xlNoMailSystem |
0 |
xlPowerTalk |
2 |
XlMarkerStyle
Constant |
Value |
xlMarkerStyleAutomatic |
-4105 |
xlMarkerStyleCircle |
8 |
xlMarkerStyleDash |
-4115 |
xlMarkerStyleDiamond |
2 |
xlMarkerStyleDot |
-4118 |
xlMarkerStyleNone |
-4142 |
xlMarkerStylePicture |
-4147 |
xlMarkerStylePlus |
9 |
xlMarkerStyleSquare |
1 |
xlMarkerStyleStar |
5 |
xlMarkerStyleTriangle |
3 |
xlMarkerStyleX |
-4168 |
XlMouseButton
Constant |
Value |
xlNoButton |
0 |
xlPrimaryButton |
1 |
xlSecondaryButton |
2 |
XlMousePointer
Constant |
Value |
xlDefault |
-4143 |
xlIBeam |
3 |
xlNorthwestArrow |
1 |
xlWait |
2 |
XlMSApplication
Constant |
Value |
xlMicrosoftAccess |
4 |
xlMicrosoftFoxPro |
5 |
xlMicrosoftMail |
3 |
xlMicrosoftPowerPoint |
2 |
xlMicrosoftProject |
6 |
xlMicrosoftSchedulePlus |
7 |
xlMicrosoftWord |
1 |
XlObjectSize
Constant |
Value |
xlFitToPage |
2 |
xlFullPage |
3 |
xlScreenSize |
1 |
XlOLEType
Constant |
Value |
xlOLEControl |
2 |
xlOLEEmbed |
1 |
xlOLELink |
0 |
XlOLEVerb
Constant |
Value |
xlVerbOpen |
2 |
xlVerbPrimary |
1 |
XlOrder
Constant |
Value |
xlDownThenOver |
1 |
xlOverThenDown |
2 |
XlOrientation
Constant |
Value |
xlDownward |
-4170 |
xlHorizontal |
-4128 |
xlUpward |
-4171 |
xlVertical |
-4166 |
XlPageBreak
Constant |
Value |
xlPageBreakAutomatic |
-4105 |
xlPageBreakManual |
-4135 |
xlPageBreakNone |
-4142 |
XlPageBreakExtent
Constant |
Value |
xlPageBreakFull |
1 |
xlPageBreakPartial |
2 |
XlPageOrientation
Constant |
Value |
xlLandscape |
2 |
xlPortrait |
1 |
XlPaperSize
Constant |
Value |
xlPaper10x14 |
16 |
xlPaper11x17 |
17 |
xlPaperA3 |
8 |
xlPaperA4 |
9 |
xlPaperA4Small |
10 |
xlPaperA5 |
11 |
xlPaperB4 |
12 |
xlPaperB5 |
13 |
xlPaperCsheet |
24 |
xlPaperDsheet |
25 |
xlPaperEnvelope10 |
20 |
xlPaperEnvelope11 |
21 |
xlPaperEnvelope12 |
22 |
xlPaperEnvelope14 |
23 |
xlPaperEnvelope9 |
19 |
xlPaperEnvelopeB4 |
33 |
xlPaperEnvelopeB5 |
34 |
xlPaperEnvelopeB6 |
35 |
xlPaperEnvelopeC3 |
29 |
xlPaperEnvelopeC4 |
30 |
xlPaperEnvelopeC5 |
28 |
xlPaperEnvelopeC6 |
31 |
xlPaperEnvelopeC65 |
32 |
xlPaperEnvelopeDL |
27 |
xlPaperEnvelopeItaly |
36 |
xlPaperEnvelopeMonarch |
37 |
xlPaperEnvelopePersonal |
38 |
xlPaperEsheet |
26 |
xlPaperExecutive |
7 |
xlPaperFanfoldLegalGerman |
41 |
xlPaperFanfoldStdGerman |
40 |
xlPaperFanfoldUS |
39 |
xlPaperFolio |
14 |
xlPaperLedger |
4 |
xlPaperLegal |
5 |
xlPaperLetter |
1 |
xlPaperLetterSmall |
2 |
xlPaperNote |
18 |
xlPaperQuarto |
15 |
xlPaperStatement |
6 |
xlPaperTabloid |
3 |
xlPaperUser |
256 |
XlParameterDataType
Constant |
Value |
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
Constant |
Value |
xlConstant |
1 |
xlPrompt |
0 |
xlRange |
2 |
XlPasteSpecialOperation
Constant |
Value |
xlPasteSpecialOperationAdd |
2 |
xlPasteSpecialOperationDivide |
5 |
xlPasteSpecialOperationMultiply |
4 |
xlPasteSpecialOperationNone |
-4142 |
xlPasteSpecialOperationSubtract |
3 |
XlPasteType
Constant |
Value |
xlPasteAll |
-4104 |
xlPasteAllExceptBorders |
7 |
xlPasteColumnWidths |
8 |
xlPasteComments |
-4144 |
xlPasteFormats |
-4122 |
xlPasteFormulas |
-4123 |
xlPasteFormulasAndNumberFormats |
11 |
xlPasteValidation |
6 |
xlPasteValues |
-4163 |
xlPasteValuesAndNumberFormats |
12 |
XlPattern
Constant |
Value |
xlPatternAutomatic |
-4105 |
xlPatternChecker |
9 |
xlPatternCrissCross |
16 |
xlPatternDown |
-4121 |
xlPatternGray16 |
17 |
xlPatternGray25 |
-4124 |
xlPatternGray50 |
-4125 |
xlPatternGray75 |
-4126 |
xlPatternGray8 |
18 |
xlPatternGrid |
15 |
xlPatternHorizontal |
-4128 |
xlPatternLightDown |
13 |
xlPatternLightHorizontal |
11 |
xlPatternLightUp |
14 |
xlPatternLightVertical |
12 |
xlPatternNone |
-4142 |
xlPatternSemiGray75 |
10 |
xlPatternSolid |
1 |
xlPatternUp |
-4162 |
xlPatternVertical |
-4166 |
XlPhoneticAlignment
Constant |
Value |
xlPhoneticAlignCenter |
2 |
xlPhoneticAlignDistributed |
3 |
xlPhoneticAlignLeft |
1 |
xlPhoneticAlignNoControl |
0 |
XlPhoneticCharacterType
Constant |
Value |
xlHiragana |
2 |
xlKatakana |
1 |
xlKatakanaHalf |
0 |
xlNoConversion |
3 |
XlPictureAppearance
Constant |
Value |
xlPrinter |
2 |
xlScreen |
1 |
XlPictureConvertorType
Constant |
Value |
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 |
XlPivotCellType
Constant |
Value |
xlPivotCellBlankCell |
9 |
xlPivotCellCustomSubtotal |
7 |
xlPivotCellDataField |
4 |
xlPivotCellDataPivotField |
8 |
xlPivotCellGrandTotal |
3 |
xlPivotCellPageFieldItem |
6 |
xlPivotCellPivotField |
5 |
xlPivotCellPivotItem |
1 |
xlPivotCellSubtotal |
2 |
xlPivotCellValue |
0 |
XlPivotFieldCalculation
Constant |
Value |
xlDifferenceFrom |
2 |
xlIndex |
9 |
xlNoAdditionalCalculation |
-4143 |
xlPercentDifferenceFrom |
4 |
xlPercentOf |
3 |
xlPercentOfColumn |
7 |
xlPercentOfRow |
6 |
xlPercentOfTotal |
8 |
xlRunningTotal |
5 |
XlPivotFieldDataType
Constant |
Value |
xlDate |
2 |
xlNumber |
-4145 |
xlText |
-4158 |
XlPivotFieldOrientation
Constant |
Value |
xlColumnField |
2 |
xlDataField |
4 |
xlHidden |
0 |
xlPageField |
3 |
xlRowField |
1 |
XlPivotFormatType
Constant |
Value |
xlPTClassic |
20 |
xlPTNone |
21 |
xlReport1 |
0 |
xlReport10 |
9 |
xlReport2 |
1 |
xlReport3 |
2 |
xlReport4 |
3 |
xlReport5 |
4 |
xlReport6 |
5 |
xlReport7 |
6 |
xlReport8 |
7 |
xlReport9 |
8 |
xlTable1 |
10 |
xlTable10 |
19 |
xlTable2 |
11 |
xlTable3 |
12 |
xlTable4 |
13 |
xlTable5 |
14 |
xlTable6 |
15 |
xlTable7 |
16 |
xlTable8 |
17 |
xlTable9 |
18 |
XlPivotTableMissingItems
Constant |
Value |
xlMissingItemsDefault |
-1 |
xlMissingItemsMax |
32500 |
xlMissingItemsNone |
0 |
XlPivotTableSourceType
Constant |
Value |
xlConsolidation |
3 |
xlDatabase |
1 |
xlExternal |
2 |
xlPivotTable |
-4148 |
xlScenario |
4 |
XlPivotTableVersionList
Constant |
Value |
xlPivotTableVersion10 |
1 |
xlPivotTableVersion2000 |
0 |
xlPivotTableVersionCurrent |
-1 |
XlPlacement
Constant |
Value |
xlFreeFloating |
3 |
xlMove |
2 |
xlMoveAndSize |
1 |
XlPlatform
Constant |
Value |
xlMacintosh |
1 |
xlMSDOS |
3 |
xlWindows |
2 |
XlPrintErrors
Constant |
Value |
xlPrintErrorsBlank |
1 |
xlPrintErrorsDash |
2 |
xlPrintErrorsDisplayed |
0 |
xlPrintErrorsNA |
3 |
XlPrintLocation
Constant |
Value |
xlPrintInPlace |
16 |
xlPrintNoComments |
-4142 |
xlPrintSheetEnd |
1 |
XlPriority
Constant |
Value |
xlPriorityHigh |
-4127 |
xlPriorityLow |
-4134 |
xlPriorityNormal |
-4143 |
XlPTSelectionMode
Constant |
Value |
xlBlanks |
4 |
xlButton |
15 |
xlDataAndLabel |
0 |
xlDataOnly |
2 |
xlFirstRow |
256 |
xlLabelOnly |
1 |
xlOrigin |
3 |
XlQueryType
Constant |
Value |
xlADORecordset |
7 |
xlDAORecordset |
2 |
xlODBCQuery |
1 |
xlOLEDBQuery |
5 |
xlTextImport |
6 |
xlWebQuery |
4 |
XlRangeAutoFormat
Constant |
Value |
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
Constant |
Value |
xlRangeValueDefault |
10 |
xlRangeValueMSPersistXML |
12 |
xlRangeValueXMLSpreadsheet |
11 |
XlReferenceStyle
Constant |
Value |
xlA1 |
1 |
xlR1C1 |
-4150 |
XlReferenceType
Constant |
Value |
xlAbsolute |
1 |
xlAbsRowRelColumn |
2 |
xlRelative |
4 |
xlRelRowAbsColumn |
3 |
XlRobustConnect
Constant |
Value |
xlAlways |
1 |
xlAsRequired |
0 |
xlNever |
2 |
XlRoutingSlipDelivery
Constant |
Value |
xlAllAtOnce |
2 |
xlOneAfterAnother |
1 |
XlRoutingSlipStatus
Constant |
Value |
xlNotYetRouted |
0 |
xlRoutingComplete |
2 |
xlRoutingInProgress |
1 |
XlRowCol
Constant |
Value |
xlColumns |
2 |
xlRows |
1 |
XlRunAutoMacro
Constant |
Value |
xlAutoActivate |
3 |
xlAutoClose |
2 |
xlAutoDeactivate |
4 |
xlAutoOpen |
1 |
XlSaveAction
Constant |
Value |
xlDoNotSaveChanges |
2 |
xlSaveChanges |
1 |
XlSaveAsAccessMode
Constant |
Value |
xlExclusive |
3 |
xlNoChange |
1 |
xlShared |
2 |
XlSaveConflictResolution
Constant |
Value |
xlLocalSessionChanges |
2 |
xlOtherSessionChanges |
3 |
xlUserResolution |
1 |
XlScaleType
Constant |
Value |
xlScaleLinear |
-4132 |
xlScaleLogarithmic |
-4133 |
XlSearchDirection
Constant |
Value |
xlNext |
1 |
xlPrevious |
2 |
XlSearchOrder
Constant |
Value |
xlByColumns |
2 |
xlByRows |
1 |
XlSearchWithin
Constant |
Value |
xlWithinSheet |
1 |
xlWithinWorkbook |
2 |
XlSheetType
Constant |
Value |
xlChart |
-4109 |
xlDialogSheet |
-4116 |
xlExcel4IntlMacroSheet |
4 |
xlExcel4MacroSheet |
3 |
xlWorksheet |
-4167 |
XlSheetVisibility
Constant |
Value |
xlSheetHidden |
0 |
xlSheetVeryHidden |
2 |
xlSheetVisible |
-1 |
XlSizeRepresents
Constant |
Value |
xlSizeIsArea |
1 |
xlSizeIsWidth |
2 |
XlSmartTagControlType
Constant |
Value |
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 |
XlSmartTagDisplayMode
Constant |
Value |
xlButtonOnly |
2 |
xlDisplayNone |
1 |
xlIndicatorAndButton |
0 |
XlSortDataOption
Constant |
Value |
xlSortNormal |
0 |
xlSortTextAsNumbers |
1 |
XlSortMethod
Constant |
Value |
xlPinYin |
1 |
xlStroke |
2 |
XlSortMethodOld
Constant |
Value |
xlCodePage |
2 |
xlSyllabary |
1 |
XlSortOrder
Constant |
Value |
xlAscending |
1 |
xlDescending |
2 |
XlSortOrientation
Constant |
Value |
xlSortColumns |
1 |
xlSortRows |
2 |
XlSortType
Constant |
Value |
xlSortLabels |
2 |
xlSortValues |
1 |
XlSourceType
Constant |
Value |
xlSourceAutoFilter |
3 |
xlSourceChart |
5 |
xlSourcePivotTable |
6 |
xlSourcePrintArea |
2 |
xlSourceQuery |
7 |
xlSourceRange |
4 |
xlSourceSheet |
1 |
xlSourceWorkbook |
0 |
XlSpeakDirection
Constant |
Value |
xlSpeakByColumns |
1 |
xlSpeakByRows |
0 |
XlSpecialCellsValue
Constant |
Value |
xlErrors |
16 |
xlLogical |
4 |
xlNumbers |
1 |
xlTextValues |
2 |
XlSubscribeToFormat
Constant |
Value |
xlSubscribeToPicture |
-4147 |
xlSubscribeToText |
-4158 |
XlSubtototalLocationType
Constant |
Value |
xlAtBottom |
2 |
xlAtTop |
1 |
XlSummaryColumn
Constant |
Value |
xlSummaryOnLeft |
-4131 |
xlSummaryOnRight |
-4152 |
XlSummaryReportType
Constant |
Value |
xlStandardSummary |
1 |
xlSummaryPivotTable |
-4148 |
XlSummaryRow
Constant |
Value |
xlSummaryAbove |
0 |
xlSummaryBelow |
1 |
XlTabPosition
Constant |
Value |
xlTabPositionFirst |
0 |
xlTabPositionLast |
1 |
XlTextParsingType
Constant |
Value |
xlDelimited |
1 |
xlFixedWidth |
2 |
XlTextQualifier
Constant |
Value |
xlTextQualifierDoubleQuote |
1 |
xlTextQualifierNone |
-4142 |
xlTextQualifierSingleQuote |
2 |
XlTextVisualLayoutType
Constant |
Value |
xlTextVisualLTR |
1 |
xlTextVisualRTL |
2 |
XlTickLabelOrientation
Constant |
Value |
xlTickLabelOrientationAutomatic |
-4105 |
xlTickLabelOrientationDownward |
-4170 |
xlTickLabelOrientationHorizontal |
-4128 |
xlTickLabelOrientationUpward |
-4171 |
xlTickLabelOrientationVertical |
-4166 |
XlTickLabelPosition
Constant |
Value |
xlTickLabelPositionHigh |
-4127 |
xlTickLabelPositionLow |
-4134 |
xlTickLabelPositionNextToAxis |
4 |
xlTickLabelPositionNone |
-4142 |
XlTickMark
Constant |
Value |
xlTickMarkCross |
4 |
xlTickMarkInside |
2 |
xlTickMarkNone |
-4142 |
xlTickMarkOutside |
3 |
XlTimeUnit
Constant |
Value |
xlDays |
0 |
xlMonths |
1 |
xlYears |
2 |
XlToolbarProtection
Constant |
Value |
xlNoButtonChanges |
1 |
xlNoChanges |
4 |
xlNoDockingChanges |
3 |
xlNoShapeChanges |
2 |
xlToolbarProtectionNone |
-4143 |
XlTotalsCalculation
Constant |
Value |
xlTotalsCalculationAverage |
2 |
xlTotalsCalculationCount |
3 |
xlTotalsCalculationCountNums |
4 |
xlTotalsCalculationMax |
6 |
xlTotalsCalculationMin |
5 |
xlTotalsCalculationNone |
0 |
xlTotalsCalculationStdDev |
7 |
xlTotalsCalculationSum |
1 |
xlTotalsCalculationVar |
8 |
XlTrendlineType
Constant |
Value |
xlExponential |
5 |
xlLinear |
-4132 |
xlLogarithmic |
-4133 |
xlMovingAvg |
6 |
xlPolynomial |
3 |
xlPower |
4 |
XlUnderlineStyle
Constant |
Value |
xlUnderlineStyleDouble |
-4119 |
xlUnderlineStyleDoubleAccounting |
5 |
xlUnderlineStyleNone |
-4142 |
xlUnderlineStyleSingle |
2 |
xlUnderlineStyleSingleAccounting |
4 |
XlUpdateLinks
Constant |
Value |
xlUpdateLinksAlways |
3 |
xlUpdateLinksNever |
2 |
xlUpdateLinksUserSetting |
1 |
XlVAlign
Constant |
Value |
xlVAlignBottom |
-4107 |
xlVAlignCenter |
-4108 |
xlVAlignDistributed |
-4117 |
xlVAlignJustify |
-4130 |
xlVAlignTop |
-4160 |
XlWBATemplate
Constant |
Value |
xlWBATChart |
-4109 |
xlWBATExcel4IntlMacroSheet |
4 |
xlWBATExcel4MacroSheet |
3 |
xlWBATWorksheet |
-4167 |
XlWebFormatting
Constant |
Value |
xlWebFormattingAll |
1 |
xlWebFormattingNone |
3 |
xlWebFormattingRTF |
2 |
XlWebSelectionType
Constant |
Value |
xlAllTables |
2 |
xlEntirePage |
1 |
xlSpecifiedTables |
3 |
XlWindowState
Constant |
Value |
xlMaximized |
-4137 |
xlMinimized |
-4140 |
xlNormal |
-4143 |
XlWindowType
Constant |
Value |
xlChartAsWindow |
5 |
xlChartInPlace |
4 |
xlClipboard |
3 |
xlInfo |
-4129 |
xlWorkbook |
1 |
XlWindowView
Constant |
Value |
xlNormalView |
1 |
xlPageBreakPreview |
2 |
XlXLMMacroType
Constant |
Value |
xlCommand |
2 |
xlFunction |
1 |
xlNotXLM |
3 |
XlXmlExportResult
Constant |
Value |
xlXmlExportSuccess |
0 |
xlXmlExportValidationFailed |
1 |
XlXmlImportResult
Constant |
Value |
xlXmlImportElementsTruncated |
1 |
xlXmlImportSuccess |
0 |
xlXmlImportValidationFailed |
2 |
XlXmlLoadOption
Constant |
Value |
xlXmlLoadImportToList |
2 |
xlXmlLoadMapXml |
3 |
xlXmlLoadOpenXml |
1 |
xlXmlLoadPromptUser |
0 |
XlYesNoGuess
Constant |
Value |
xlGuess |
0 |
xlNo |
2 |
xlYes |
1 |