GridlineColorIndex Property

Microsoft Excel Visual Basic

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