FillStyle (Grid)

Returns or sets a value that determines whether setting the Text property or one of the cell formatting properties of a Grid applies the change to all selected cells.

Syntax

object.FillStyle[ = value ]

The FillStyle property syntax has these parts:

Part Description
object An object expression that evaluates to an object.
value Integer or constant that specifies the fill style, as described in Settings.

Settings

The settings for value are:

Value Description
0 Single (default). Changing Text or any of the cell properties only affects the active cell.
1 Repeat. Changing the Text or any of the cell properties affects all selected cells.

Remarks

FillStyle must be set to 1(Repeat) whenever you want a cell change to apply to all cells.