This documentation is archived and is not being maintained.

FillPattern cell (Fill Format section)

FillPattern cell (Fill Format section)

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

https://msdn.microsoft.com/en-us/library/aa200221(v=office.10) See also         https://msdn.microsoft.com/en-us/library/aa200721(v=office.10) Section         Rows

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 (click Fill on the Format menu).

To reference the FillPattern cell by name from another formula, or from a program using the https://msdn.microsoft.com/en-us/library/aa141912(v=office.10) Cells property, use:

Cell name:

FillPattern

To reference the FillPattern cell by index from a program, use the https://msdn.microsoft.com/en-us/library/aa141916(v=office.10) CellsSRC property with the following arguments:

Section index:

visSectionObject

Row index:

visRowFill

Cell index:

visFillPattern

Show: