GridlineColorIndex Property

Microsoft Excel Visual Basic

Show All

GridlineColorIndex Property

       

Returns or sets the gridline color as an index into the current color palette or as the following XlColorIndex constant.

XlColorIndex can be the following XlColorIndex constant.
xlColorIndexAutomatic

expression.GridlineColorIndex

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

Set this property to xlColorIndexAutomatic to specify the automatic color.

The following illustration shows the color-index values in the default color palette.

Color index values in default color palette

Example

This example sets the gridline color in the active window to blue.

ActiveWindow.GridlineColorIndex = 5