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:

Value
Cell name:
FillPattern

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

Value
Section index:
visSectionObject
Row index:
visRowFill
Cell index:
visFillPattern