Skip to main content

XlPattern enumeration

Specifies the interior pattern of a chart or interior object.

Name Value Description
xlPatternAutomatic -4105 Excel controls the pattern.
xlPatternChecker 9 Checkerboard.
xlPatternCrissCross 16 Criss-cross lines.
xlPatternDown -4121 Dark diagonal lines running from the upper-left to the lower-right.
xlPatternGray16 17 16% gray.
xlPatternGray25 -4124 25% gray.
xlPatternGray50 -4125 50% gray.
xlPatternGray75 -4126 75% gray.
xlPatternGray8 18 8% gray.
xlPatternGrid 15 Grid.
xlPatternHorizontal -4128 Dark horizontal lines.
xlPatternLightDown 13 Light diagonal lines running from the upper-left to the lower-right.
xlPatternLightHorizontal 11 Light horizontal lines.
xlPatternLightUp 14 Light diagonal lines running from the lower-left to the upper-right.
xlPatternLightVertical 12 Light vertical bars.
xlPatternNone -4142 No pattern.
xlPatternSemiGray75 10 75% dark gray.
xlPatternSolid 1 Solid color.
xlPatternUp -4162 Dark diagonal lines running from the lower-left to the upper-right.
xlPatternVertical -4166 Dark vertical bars.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>