Skip to main content

Interior.PatternTintAndShade property

Table of contents
  1. Syntax
  2. Examples

Returns or sets a tint and shade pattern for an Interior object. Read/write Variant.



expression A variable that represents an Interior object.


The following example sets the interior pattern for Range G2:G5.

With Range("G2:G5").Interior
    .Pattern = xlGray75
    .PatternThemeColor = xlThemeColorLight1
    .ColorIndex = xlAutomatic
    .TintAndShade = 0
    .PatternTintAndShade = 0.8
End With

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>