Constants enumeration (Excel)

This enumeration groups together constants used with various Excel methods.


Name Value Description
xl3DBar -4099 3D Bar
xl3DEffects1 13 3D Effects1
xl3DEffects2 14 3D Effects2
xl3DSurface -4103 3D Surface
xlAbove 0 Above
xlAccounting1 4 Accounting1
xlAccounting2 5 Accounting2
xlAccounting4 17 Accounting4
xlAdd 2 Add
xlAll -4104 All
xlAccounting3 6 Accounting3
xlAllExceptBorders 7 All Except Borders
xlAutomatic -4105 Automatic
xlBar 2 Automatic
xlBelow 1 Below
xlBidi -5000 Bidi
xlBidiCalendar 3 BidiCalendar
xlBoth 1 Both
xlBottom -4107 Bottom
xlCascade 7 Cascade
xlCenter -4108 Center
xlCenterAcrossSelection 7 Center Across Selection
xlChart4 2 Chart 4
xlChartSeries 17 Chart Series
xlChartShort 6 Chart Short
xlChartTitles 18 Chart Titles
xlChecker 9 Checker
xlCircle 8 Circle
xlClassic1 1 Classic1
xlClassic2 2 Classic2
xlClassic3 3 Classic3
xlClosed 3 Closed
xlColor1 7 Color1
xlColor2 8 Color2
xlColor3 9 Color3
xlColumn 3 Column
xlCombination -4111 Combination
xlComplete 4 Complete
xlConstants 2 Constants
xlContents 2 Contents
xlContext -5002 Context
xlCorner 2 Corner
xlCrissCross 16 CrissCross
xlCross 4 Cross
xlCustom -4114 Custom
xlDebugCodePane 13 Debug Code Pane
xlDefaultAutoFormat -1 Default Auto Format
xlDesktop 9 Desktop
xlDiamond 2 Diamond
xlDirect 1 Direct
xlDistributed -4117 Distributed
xlDivide 5 Divide
xlDoubleAccounting 5 Double Accounting
xlDoubleClosed 5 Double Closed
xlDoubleOpen 4 Double Open
xlDoubleQuote 1 Double Quote
xlDrawingObject 14 Drawing Object
xlEntireChart 20 Entire Chart
xlExcelMenus 1 Excel Menus
xlExtended 3 Extended
xlFill 5 Fill
xlFirst 0 First
xlFixedValue 1 Fixed Value
xlFloating 5 Floating
xlFormats -4122 Formats
xlFormula 5 Formula
xlFullScript 1 Full Script
xlGeneral 1 General
xlGray16 17 Gray16
xlGray25 -4124 Gray25
xlGray50 -4125 Gray50
xlGray75 -4126 Gray75
xlGray8 18 Gray8
xlGregorian 2 Gregorian
xlGrid 15 Grid
xlGridline 22 Gridline
xlHigh -4127 High
xlHindiNumerals 3 Hindi Numerals
xlIcons 1 Icons
xlImmediatePane 12 Immediate Pane
xlInside 2 Inside
xlInteger 2 Integer
xlJustify -4130 Justify
xlLast 1 Last
xlLastCell 11 Last Cell
xlLatin -5001 Latin
xlLeft -4131 Left
xlLeftToRight 2 Left To Right
xlLightDown 13 Light Down
xlLightHorizontal 11 Light Horizontal
xlLightUp 14 Light Up
xlLightVertical 12 Light Vertical
xlList1 10 List1
xlList2 11 List2
xlList3 12 List3
xlLocalFormat1 15 Local Format1
xlLocalFormat2 16 Local Format2
xlLogicalCursor 1 Logical Cursor
xlLong 3 Long
xlLotusHelp 2 Lotus Help
xlLow -4134 Low
xlLTR -5003 LTR
xlMacrosheetCell 7 MacrosheetCell
xlManual -4135 Manual
xlMaximum 2 Maximum
xlMinimum 4 Minimum
xlMinusValues 3 Minus Values
xlMixed 2 Mixed
xlMixedAuthorizedScript 4 Mixed Authorized Script
xlMixedScript 3 Mixed Script
xlModule -4141 Module
xlMultiply 4 Multiply
xlNarrow 1 Narrow
xlNextToAxis 4 Next To Axis
xlNoDocuments 3 No Documents
xlNone -4142 None
xlNotes -4144 Notes
xlOff -4146 Off
xlOn 1 On
xlOpaque 3 Opaque
xlOpen 2 Open
xlOutside 3 Outside
xlPartial 3 Partial
xlPartialScript 2 Partial Script
xlPercent 2 Percent
xlPlus 9 Plus
xlPlusValues 2 Plus Values
xlReference 4 Reference
xlRight -4152 Right
xlRTL -5004 RTL
xlScale 3 Scale
xlSemiautomatic 2 Semiautomatic
xlSemiGray75 10 SemiGray75
xlShort 1 Short
xlShowLabel 4 Show Label
xlShowLabelAndPercent 5 Show Label and Percent
xlShowPercent 3 Show Percent
xlShowValue 2 Show Value
xlSimple -4154 Simple
xlSingle 2 Single
xlSingleAccounting 4 Single Accounting
xlSingleQuote 2 Single Quote
xlSolid 1 Solid
xlSquare 1 Square
xlStar 5 Star
xlStError 4 St Error
xlStrict 2 Strict
xlSubtract 3 Subtract
xlSystem 1 System
xlTextBox 16 Text Box
xlTiled 1 Tiled
xlTitleBar 8 Title Bar
xlToolbar 1 Toolbar
xlToolbarButton 2 Toolbar Button
xlTop -4160 Top
xlTopToBottom 1 Top To Bottom
xlTransparent 2 Transparent
xlTriangle 3 Triangle
xlVeryHidden 2 Very Hidden
xlVisible 12 Visible
xlVisualCursor 2 Visual Cursor
xlWatchPane 11 Watch Pane
xlWide 3 Wide
xlWorkbookTab 6 Workbook Tab
xlWorksheet4 1 Worksheet4
xlWorksheetCell 3 Worksheet Cell
xlWorksheetShort 5 Worksheet Short

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.