Skip to main content

Interior.ColorIndex property

Table of contents
  1. Syntax
  2. Remarks
  3. Examples

Returns or sets a Variant value that represents the color of the interior.

Syntax

expression.ColorIndex

expression A variable that represents an Interior object.

Remarks

The color is specified as an index value into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone.

Examples

The following example sets the background color of range A1:D1 to 1.

Range("A1:D1").Interior.ColorIndex = 1

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>