FillPattern Cell (Fill Format Section)

Determines the fill pattern for the shape. To specify a custom fill pattern, use the USE function in this cell.

Value

Description

0

None (transparent fill).

1

Solid foreground color.

2 - 40

Assorted fill patterns that correspond to indexed entries in the Fill dialog box.

Remarks

You can also set this value using the Fill dialog box (on the Home tab, in the Shape group, click Fill and then click Fill Options).

To get a reference to the FillPattern cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

FillPattern

To get a reference to the FillPattern cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionObject

Row index:

visRowFill

Cell index:

visFillPattern