Excel Constants

List of Excel Constants used in IDEAScript macros for Excel.

Global Const msoFileDialogFilePicker = 3 'File picker Dialog box.
Global Const msoFileDialogFolderPicker = 4 'Folder picker Dialog box.
Global Const msoFileDialogOpen = 1 'Open Dialog box.
Global Const msoFileDialogSaveAs = 2 'Save As Dialog box.

' BrowseForFolder params:
Global Const WINDOW_HANDLE = 0 ' Must ALWAYS be 0
Global Const MY_COMPUTER = 17 ' &H11& See ssfDRIVES below
Global Const NUM_OPTIONS = 16 ' &H10&

'ShellSpecialFolderConstants enumeration
Global Const ssfDRIVES = 17 '0x11 (17). My Computer—the virtual folder that contains everything On the local computer: storage devices, printers, And Control Panel. This folder can also contain mapped network drives.

'XlFileFormat Enumeration
'Office 2007
Global Const xlAddIn = 18 'Microsoft Excel 97-2003 Add-In
Global Const xlAddIn8 = 18 'Microsoft Excel 97-2003 Add-In
Global Const xlCSV = 6 'CSV
Global Const xlCSVMac = 22 'Macintosh CSV
Global Const xlCSVMSDOS = 24 'MSDOS CSV
Global Const xlCSVWindows = 23 'Windows CSV
Global Const xlCurrentPlatformText = -4158 'Current Platform Text
Global Const xlDBF2 = 7 'DBF2
Global Const xlDBF3 = 8 'DBF3
Global Const xlDBF4 = 11 'DBF4
Global Const xlDIF = 9 'DIF
Global Const xlExcel12 = 50 'Excel12
Global Const xlExcel2 = 16 'Excel2
Global Const xlExcel2FarEast = 27 'Excel2 FarEast
Global Const xlExcel3 = 29 'Excel3
Global Const xlExcel4 = 33 'Excel4
Global Const xlExcel4Workbook = 35 'Excel4 Workbook
Global Const xlExcel5 = 39 'Excel5
Global Const xlExcel7 = 39 'Excel7
Global Const xlExcel8 = 56 'Excel8
Global Const xlExcel9795 = 43 'Excel9795
Global Const xlHtml = 44 'HTML Format
Global Const xlIntlAddIn = 26 'International Add-In
Global Const xlIntlMacro = 25 'International Macro
Global Const xlOpenDocumentSpreadsheet = 60 'OpenDocument Spreadsheet
Global Const xlOpenXMLAddIn = 55 'Open XML Add-In
Global Const xlOpenXMLTemplate = 54 'Open XML Template
Global Const xlOpenXMLTemplateMacroEnabled = 53 'Open XML Template Macro Enabled
Global Const xlOpenXMLWorkbook = 51 'Open XML Workbook
Global Const xlOpenXMLWorkbookMacroEnabled = 52 'Open XML Workbook Macro Enabled
Global Const xlSYLK = 2 'SYLK
Global Const xlTemplate = 17 'Template
Global Const xlTemplate8 = 17 'Template 8
Global Const xlTextMac = 19 'Macintosh Text
Global Const xlTextMSDOS = 21 'MSDOS Text
Global Const xlTextPrinter = 36 'Printer Text
Global Const xlTextWindows = 20 'Windows Text
Global Const xlUnicodeText = 42 'Unicode Text
Global Const xlWebArchive = 45 'Web Archive
Global Const xlWJ2WD1 = 14 'WJ2WD1
Global Const xlWJ3 = 40 'WJ3
Global Const xlWJ3FJ3 = 41 'WJ3FJ3
Global Const xlWK1 = 5 'WK1
Global Const xlWK1ALL = 31 'WK1ALL
Global Const xlWK1FMT = 30 'WK1FMT
Global Const xlWK3 = 15 'WK3
Global Const xlWK3FM3 = 32 'WK3FM3
Global Const xlWK4 = 38 'WK4
Global Const xlWKS = 4 'Worksheet
Global Const xlWorkbookDefault = 51 'Workbook default
Global Const xlWorkbookNormal = -4143 'Workbook normal
Global Const xlWorks2FarEast = 28 'Works2 FarEast
Global Const xlWQ1 = 34 'WQ1
Global Const xlXMLSpreadsheet = 46 'XML Spreadshee
'old Enumeration
Global Const txtFileFormat = -4158 ' FileExtStr = ".txt"
Global Const csvFileFormat = 6 ' FileExtStr = ".csv"
Global Const xlsxFileFormat = 51 ' FileExtStr = ".xlsx"

'XlDirection Enumeration (Excel)
'Office 2013 And later Other Versions
Global Const xlDown = -4121 'Down.
Global Const xlToLeft = -4159 'To Left.
Global Const xlToRight = -4161 'To Right.
Global Const xlUp = -4162 'Up.

'XlPasteType Enumeration (Excel)
'Office 2013 And later Other Versions
' Name Value Description
Global Const xlPasteAll = -4104 'Everything will be pasted.
Global Const xlPasteAllExceptBorders = 7 'Everything except borders will be pasted.
Global Const xlPasteAllMergingConditionalFormats = 14 'Everything will be pasted And conditional formats will be merged.
Global Const xlPasteAllUsingSourceTheme = 13 'Everything will be pasted using the source theme.
Global Const xlPasteColumnWidths = 8 'Copied column width is pasted.
Global Const xlPasteComments = -4144 'Comments are pasted.
Global Const xlPasteFormats = -4122 'Copied source Format is pasted.
Global Const xlPasteFormulas = -4123 'Formulas are pasted.
Global Const xlPasteFormulasAndNumberFormats = 11 'Formulas And Number formats are pasted.
Global Const xlPasteValidation = 6 'Validations are pasted.
Global Const xlPasteValues = -4163 'Values are pasted.
Global Const xlPasteValuesAndNumberFormats = 12 'Values And Number formats are pasted.

'Constants enumeration
'Office 2013 And later Other Versions
'Public enum Constants
'Members
' Member Name Value Description
Global Const xlAll = -4104
Global Const xlAutomatic = -4105
Global Const xlBoth = 1
Global Const xlCenter = -4108
Global Const xlChecker = 9
Global Const xlCircle = 8
Global Const xlCorner = 2
Global Const xlCrissCross = 16
Global Const xlCross = 4
Global Const xlDiamond = 2
Global Const xlDistributed = -4117
Global Const xlDoubleAccounting = 5
Global Const xlFixedValue = 1
Global Const xlFormats = -4122
Global Const xlGray16 = 17
Global Const xlGray8 = 18
Global Const xlGrid = 15
Global Const xlHigh = -4127
Global Const xlInside = 2
Global Const xlJustify = -4130
Global Const xlLightDown = 13
Global Const xlLightHorizontal = 11
Global Const xlLightUp = 14
Global Const xlLightVertical = 12
Global Const xlLow = -4134
Global Const xlManual = -4135
Global Const xlMinusValues = 3
Global Const xlModule = -4141
Global Const xlNextToAxis = 4
Global Const xlNone = -4142
Global Const xlNotes = -4144
Global Const xlOff = -4146
Global Const xlOn = 1
Global Const xlPercent = 2
Global Const xlPlus = 9
Global Const xlPlusValues = 2
Global Const xlSemiGray75 = 10
Global Const xlShowLabel = 4
Global Const xlShowLabelAndPercent = 5
Global Const xlShowPercent = 3
Global Const xlShowValue = 2
Global Const xlSimple = -4154
Global Const xlSingle = 2
Global Const xlSingleAccounting = 4
Global Const xlSolid = 1
Global Const xlSquare = 1
Global Const xlStar = 5
Global Const xlStError = 4
Global Const xlToolbarButton = 2
Global Const xlTriangle = 3
Global Const xlGray25 = -4124
Global Const xlGray50 = -4125
Global Const xlGray75 = -4126
Global Const xlBottom = -4107
Global Const xlLeft = -4131
Global Const xlRight = -4152
Global Const xlTop = -4160
Global Const xl3DBar = -4099
Global Const xl3DSurface = -4103
Global Const xlBar = 2
Global Const xlColumn = 3
Global Const xlCombination = -4111
Global Const xlCustom = -4114
Global Const xlDefaultAutoFormat = -1
Global Const xlMaximum = 2
Global Const xlMinimum = 4
Global Const xlOpaque = 3
Global Const xlTransparent = 2
Global Const xlBidi = -5000
Global Const xlLatin = -5001
Global Const xlContext = -5002
Global Const xlLTR = -5003
Global Const xlRTL = -5004
Global Const xlFullScript = 1
Global Const xlPartialScript = 2
Global Const xlMixedScript = 3
Global Const xlMixedAuthorizedScript = 4
Global Const xlVisualCursor = 2
Global Const xlLogicalCursor = 1
Global Const xlSystem = 1
Global Const xlPartial = 3
Global Const xlHindiNumerals = 3
Global Const xlBidiCalendar = 3
Global Const xlGregorian = 2
Global Const xlComplete = 4
Global Const xlScale = 3
Global Const xlClosed = 3
Global Const xlColor1 = 7
Global Const xlColor2 = 8
Global Const xlColor3 = 9
Global Const xlConstants = 2
Global Const xlContents = 2
Global Const xlBelow = 1
Global Const xlCascade = 7
Global Const xlCenterAcrossSelection = 7
Global Const xlChart4 = 2
Global Const xlChartSeries = 17
Global Const xlChartShort = 6
Global Const xlChartTitles = 18
Global Const xlClassic1 = 1
Global Const xlClassic2 = 2
Global Const xlClassic3 = 3
Global Const xl3DEffects1 = 13
Global Const xl3DEffects2 = 14
Global Const xlAbove = 0
Global Const xlAccounting1 = 4
Global Const xlAccounting2 = 5
Global Const xlAccounting3 = 6
Global Const xlAccounting4 = 17
Global Const xlAdd = 2
Global Const xlDebugCodePane = 13
Global Const xlDesktop = 9
Global Const xlDirect = 1
Global Const xlDivide = 5
Global Const xlDoubleClosed = 5
Global Const xlDoubleOpen = 4
Global Const xlDoubleQuote = 1
Global Const xlEntireChart = 20
Global Const xlExcelMenus = 1
Global Const xlExtended = 3
Global Const xlFill = 5
Global Const xlFirst = 0
Global Const xlFloating = 5
Global Const xlFormula = 5
Global Const xlGeneral = 1
Global Const xlGridline = 22
Global Const xlIcons = 1
Global Const xlImmediatePane = 12
Global Const xlInteger = 2
Global Const xlLast = 1
Global Const xlLastCell = 11
Global Const xlList1 = 10
Global Const xlList2 = 11
Global Const xlList3 = 12
Global Const xlLocalFormat1 = 15
Global Const xlLocalFormat2 = 16
Global Const xlLong = 3
Global Const xlLotusHelp = 2
Global Const xlMacrosheetCell = 7
Global Const xlMixed = 2
Global Const xlMultiply = 4
Global Const xlNarrow = 1
Global Const xlNoDocuments = 3
Global Const xlOpen = 2
Global Const xlOutside = 3
Global Const xlReference = 4
Global Const xlSemiautomatic = 2
Global Const xlShort = 1
Global Const xlSingleQuote = 2
Global Const xlStrict = 2
Global Const xlSubtract = 3
Global Const xlTextBox = 16
Global Const xlTiled = 1
Global Const xlTitleBar = 8
Global Const xlToolbar = 1
Global Const xlVisible = 12
Global Const xlWatchPane = 11
Global Const xlWide = 3
Global Const xlWorkbookTab = 6
Global Const xlWorksheet4 = 1
Global Const xlWorksheetCell = 3
Global Const xlWorksheetShort = 5
Global Const xlAllExceptBorders = 7
Global Const xlLeftToRight = 2
Global Const xlTopToBottom = 1
Global Const xlVeryHidden = 2
Global Const xlDrawingObject = 14

'MsoTriState Enumeration (Office)
' Name Value Description
Global Const msoCTrue = 1 'Not supported.
Global Const msoFalse = 0 'False.
Global Const msoTriStateMixed = -2 'Not supported.
Global Const msoTriStateToggle = -3 'Not supported.
Global Const msoTrue = -1 'True.

'MsoThemeColorIndex Enumeration (Office)
'Office 2013 And later Other Versions
Global Const msoNotThemeColor = 0 'Specifies no theme color.
Global Const msoThemeColorAccent1 = 5 'Specifies the Accent 1 theme color.
Global Const msoThemeColorAccent2 = 6 'Specifies the Accent 2 theme color.
Global Const msoThemeColorAccent3 = 7 'Specifies the Accent 3 theme color.
Global Const msoThemeColorAccent4 = 8 'Specifies the Accent 4 theme color.
Global Const msoThemeColorAccent5 = 9 'Specifies the Accent 5 theme color.
Global Const msoThemeColorAccent6 = 10 'Specifies the Accent 6 theme color.
Global Const msoThemeColorBackground1 = 14 'Specifies the Background 1 theme color.
Global Const msoThemeColorBackground2 = 16 'Specifies the Background 2 theme color.
Global Const msoThemeColorDark1 = 1 'Specifies the Dark 1 theme color.
Global Const msoThemeColorDark2 = 3 'Specifies the Dark 2 theme color
Global Const msoThemeColorFollowedHyperlink = 12 'Specifies the theme color For a clicked hyperlink.
Global Const msoThemeColorHyperlink = 11 'Specifies the theme color For a hyperlink.
Global Const msoThemeColorLight1 = 2 'Specifies the Light 1 theme color.
Global Const msoThemeColorLight2 = 4 'Specifies the Light 2 theme color.
Global Const msoThemeColorMixed = -2 'Specifies a mixed color theme.
Global Const msoThemeColorText1 = 13 'Specifies the Text 1 theme color.
Global Const msoThemeColorText2 = 15 'Specifies the Text 2 theme color.

' XlChartType Enumeration
Global Const xlColumnClustered = 51 'Clustered Column

'XlAxisGroup Enumeration (Excel)
'Office 2013 And later Other Versions
Global Const xlPrimary = 1 'Primary axis group.
Global Const xlSecondary = 2 'Secondary axis group.

'XlAxisType Enumeration
Global Const xlCategory = 1
Global Const xlSeriesAxis = 3
Global Const xlValue = 2

'XlFindLookIn Enumeration
Global Const xlComments = -4144
Global Const xlFormulas = -4123
Global Const xlValues = -4163

'Microsoft Office Enumerated Constants
'Office 2003
'MsoAlignCmd Enumeration
' Constant Value Description
Global Const msoAlignBottoms = 5
Global Const msoAlignCenters = 1
Global Const msoAlignLefts = 0
Global Const msoAlignMiddles = 4
Global Const msoAlignRights = 2
Global Const msoAlignTops = 3

'MsoTextDirection Enumeration (Office)
Global Const msoTextDirectionLeftToRight = 1 'Text runs Left To Right.
Global Const msoTextDirectionMixed = -2 'Return value only; indicates a combination of the other states.
Global Const msoTextDirectionRightToLeft = 2 'Text runs Right To Left.

'MsoScaleFrom Enumeration
'Office 2007
Global Const msoScaleFromBottomRight = 2 'Shape's lower right corner retains its position.
Global Const msoScaleFromMiddle = 1 'Shape's midpoint retains its position.
Global Const msoScaleFromTopLeft = 0 'Shape's upper left corner retains its position.

'MsoChartElementType Enumeration (Office)
Global Const msoElementPrimaryCategoryAxisTitleAdjacentToAxis = 301 'Display primary category axis title adjacent To the axis.
Global Const msoElementPrimaryCategoryAxisTitleBelowAxis = 302 'Display primary category axis title below the axis.
Global Const msoElementPrimaryCategoryAxisTitleHorizontal = 305 'Display primary category axis title horizontally.
Global Const msoElementPrimaryCategoryAxisTitleNone = 300 'Do Not display primary category axis title.
Global Const msoElementPrimaryCategoryAxisTitleRotated = 303 'Rotate primary category axis title.
Global Const msoElementPrimaryCategoryAxisTitleVertical = 304 'Display primary category axis title vertically.
Global Const msoElementPrimaryCategoryAxisWithoutLabels = 350 'Display primary category axis without labels.
Global Const msoElementPrimaryCategoryGridLinesMajor = 334 'Display major gridlines along primary category axis.
Global Const msoElementPrimaryCategoryGridLinesMinor = 333 'Display minor gridlines along primary category axis.
Global Const msoElementPrimaryCategoryGridLinesMinorMajor = 335 'Display both major And minor gridlines along primary category axis.
Global Const msoElementPrimaryCategoryGridLinesNone = 332 'Do Not display grid lines along primary category axis.
Global Const msoElementPrimaryValueAxisBillions = 356 'Use billions For primary value axis units.
Global Const msoElementPrimaryValueAxisLogScale = 357 'Use Log scale For primary value axis.
Global Const msoElementPrimaryValueAxisMillions = 355 'Use millions For primary value axis units.
Global Const msoElementPrimaryValueAxisNone = 352 'Do Not display primary value axis.
Global Const msoElementPrimaryValueAxisShow = 353 'Show primary value axis
Global Const msoElementPrimaryValueAxisThousands = 354 'Use thousands For primary value axis units.
Global Const msoElementPrimaryValueAxisTitleAdjacentToAxis = 306 'Place primary value axis title adjacent To the axis.
Global Const msoElementPrimaryValueAxisTitleBelowAxis = 308 'Place primary value axis title below the axis.
Global Const msoElementPrimaryValueAxisTitleHorizontal = 311 'Display primary value axis title horizontally.
Global Const msoElementPrimaryValueAxisTitleNone = 306 'Do Not display primary value axis title.
Global Const msoElementPrimaryValueAxisTitleRotated = 309 'Rotate primary value axis title.
Global Const msoElementPrimaryValueAxisTitleVertical = 310 'Display primary value axis title vertically.
Global Const msoElementPrimaryValueGridLinesMajor = 330 'Display major gridlines along primary value axis.
Global Const msoElementPrimaryValueGridLinesMinor = 329 'Display minor gridlines along primary value axis.
Global Const msoElementPrimaryValueGridLinesMinorMajor = 331 'Display both major And minor gridlines along primary value axis.
Global Const msoElementPrimaryValueGridLinesNone = 328 'Do Not display grid lines along primary value axis.
Global Const msoElementSecondaryCategoryAxisBillions = 378 'Use billions For secondary category axis units.
Global Const msoElementSecondaryCategoryAxisLogScale = 379 'Use Log scale For secondary category axis.
Global Const msoElementSecondaryCategoryAxisMillions = 377 'Use millions For secondary category axis units.
Global Const msoElementSecondaryCategoryAxisNone = 358 'Do Not display secondary category axis.
Global Const msoElementSecondaryCategoryAxisReverse = 361 'Reverse secondary category axis.
Global Const msoElementSecondaryCategoryAxisShow = 359 'Display secondary category axis.
Global Const msoElementSecondaryCategoryAxisThousands = 376 'Use thousands For secondary category axis units.
Global Const msoElementSecondaryCategoryAxisTitleAdjacentToAxis = 313 'Dispaly secondary category axis title adjacent To axis.
Global Const msoElementSecondaryCategoryAxisTitleBelowAxis = 314 'Dispaly secondary category axis title below axis.
Global Const msoElementSecondaryCategoryAxisTitleHorizontal = 317 'Display secondary category axis title horizontally.
Global Const msoElementSecondaryCategoryAxisTitleNone = 312 'Do Not display secondary category axis title.
Global Const msoElementSecondaryCategoryAxisTitleRotated = 315 'Rotate secondary category axis title.
Global Const msoElementSecondaryCategoryAxisTitleVertical = 316 'Display secondary category axis title vertically.
Global Const msoElementSecondaryCategoryAxisWithoutLabels = 360 'Display secondary category axis without labels.
Global Const msoElementSecondaryCategoryGridLinesMajor = 342 'Display major gridlines along secondary category axis.
Global Const msoElementSecondaryCategoryGridLinesMinor = 341 'Display minor gridlines along secondary category axis.
Global Const msoElementSecondaryCategoryGridLinesMinorMajor = 343 'Display both major And minor gridlines along secondary category axis.
Global Const msoElementSecondaryCategoryGridLinesNone = 340 'Do Not display grid lines along secondary category axis.
Global Const msoElementSecondaryValueAxisBillions = 366 'Use billions For secondary value axis units.
Global Const msoElementSecondaryValueAxisLogScale = 367 'Use Log scale For secondary value axis.
Global Const msoElementSecondaryValueAxisMillions = 365 'Use millions For secondary value axis units.
Global Const msoElementSecondaryValueAxisNone = 362 'Do Not display secondary value axis.
Global Const msoElementSecondaryValueAxisShow = 363 'Display secondary value axis.
Global Const msoElementSecondaryValueAxisThousands = 364 'Use thousands For secondary value axis units.
Global Const msoElementSecondaryValueAxisTitleAdjacentToAxis = 319 'Display secondary value axis title adjacent To axis.
Global Const msoElementSecondaryValueAxisTitleBelowAxis = 320 'Display secondary value axis title below axis.
Global Const msoElementSecondaryValueAxisTitleHorizontal = 323 'Display secondary value axis title horizontally.
Global Const msoElementSecondaryValueAxisTitleNone = 318 'Do Not display secondary value axis title.
Global Const msoElementSecondaryValueAxisTitleRotated = 321 'Rotate secondary value axis title.
Global Const msoElementSecondaryValueAxisTitleVertical = 322 'Display secondary value axis title vertically.
Global Const msoElementSecondaryValueGridLinesMajor = 338 'Display major gridlines along secondary value axis.
Global Const msoElementSecondaryValueGridLinesMinor = 337 'Display minor gridlines along secondary value axis.
Global Const msoElementSecondaryValueGridLinesMinorMajor = 339 'Display both major And minor gridlines along secondary value axis.
Global Const msoElementSecondaryValueGridLinesNone = 336 'Do Not display gridlines along secondary value axis.
'
'Version Added: Excel 2007
'Name Value Description
Global Const xlThemeColorAccent1 As Long = 5 'Accent1
Global Const xlThemeColorAccent2 As Long = 6 'Accent2
Global Const xlThemeColorAccent3 As Long = 7 'Accent3
Global Const xlThemeColorAccent4 As Long = 8 'Accent4
Global Const xlThemeColorAccent5 As Long = 9 'Accent5
Global Const xlThemeColorAccent6 As Long = 10 'Accent6
Global Const xlThemeColorDark1 As Long = 1 'Dark1
Global Const xlThemeColorDark2 As Long = 3 'Dark2
Global Const xlThemeColorFollowedHyperlink As Long = 12 'Followed hyperlink
Global Const xlThemeColorHyperlink As Long = 11 'Hyperlink
Global Const xlThemeColorLight1 As Long = 2 'Light1
Global Const xlThemeColorLight2 As Long = 4 'Light2

'XlConsolidationFunction Enumeration (Excel)
'office 365 dev account|Last Updated: 6/12/2017|1 Contributor
'Specifies the subtotal Function.
'Name Value Description
Global Const xlAverage As Long = -4106 'Average.
Global Const xlCount As Long = -4112 'Count.
Global Const xlCountNums As Long = -4113 'Count numerical values only.
Global Const xlDistinctCount As Long = 111 'Count using Distinct Count analysis.
Global Const xlMax As Long = -4136 'Maximum.
Global Const xlMin As Long = -4139 'Minimum.
Global Const xlProduct As Long = -4149 'Multiply.
Global Const xlStDev As Long = -4155 'Standard deviation, based On a sample.
Global Const xlStDevP As Long = -4156 'Standard deviation, based On the whole population.
Global Const xlSum As Long = -4157 'Sum.
Global Const xlUnknown As Long = 1000 'No subtotal Function specified.
Global Const xlVar As Long = -4164 'Variation, based On a sample.
Global Const xlVarP As Long = -4165 'Variation, based On the whole population.

'XlBordersIndex Enumeration (Excel)
'office 365 dev account|Last Updated: 6/12/2017|1 Contributor
'Specifies the border To be retrieved.
'Name Value Description
Global Const xlDiagonalDown As Long = 5 'Border running from the upper Left-hand corner To the lower Right of Each cell In the range.
Global Const xlDiagonalUp As Long = 6 'Border running from the lower Left-hand corner To the upper Right of Each cell In the range.
Global Const xlEdgeBottom As Long = 9 'Border at the bottom of the range.
Global Const xlEdgeLeft As Long = 7 'Border at the Left-hand edge of the range.
Global Const xlEdgeRight As Long = 10 'Border at the Right-hand edge of the range.
Global Const xlEdgeTop As Long = 8 'Border at the top of the range.
Global Const xlInsideHorizontal As Long = 12 'Horizontal borders For all cells In the range except borders On the outside of the range.
Global Const xlInsideVertical As Long = 11 'Vertical borders For all the cells In the range except borders On the outside of the range.

'XlBorderWeight Enumeration
'Office 2007
'Excel Developer Reference
'Specifies the weight of the border around a range.
'Name Value Description
Global Const xlHairline As Long = 1 'Hairline (thinnest border).
Global Const xlMedium As Long = -4138 'Medium.
Global Const xlThick As Long = 4 'Thick (widest border).
Global Const xlThin As Long = 2 'Thin.

'XlLineStyle Enumeration
'Office 2007
'Excel Developer Reference
'Specifies the Line style For the border.
'Name Value Description
Global Const xlContinuous As Long = 1 'Continuous Line.
Global Const xlDash As Long = -4115 'Dashed Line.
Global Const xlDashDot As Long = 4 'Alternating dashes And dots.
Global Const xlDashDotDot As Long = 5 'Dash followed by two dots.
Global Const xlDot As Long = -4118 'Dotted Line.
Global Const xlDouble As Long = -4119 'Double Line.
Global Const xlLineStyleNone As Long = -4142 'No Line.
Global Const xlSlantDashDot As Long = 13 'Slanted dashes.