HotXLS Docs

Pattern property

Returns or sets the interior pattern. Read/write LongWord.

Syntax

property Pattern: LongWord;

Description

Pattern can be one of these XlPattern constants.
xlPatternAutomatic
xlPatternChecker
xlPatternCrissCross
xlPatternDown
xlpatterngray16
xlpatterngray25
xlpatterngray50
xlpatterngray75
xlpatterngray8
xlPatternGrid
xlPatternHorizontal
xlPatternLightDown
xlPatternLightHorizontal
xlPatternLightUp
xlPatternLightVertical
xlPatternNone
xlPatternSemiGray75
xlPatternSolid
xlPatternUp
xlPatternVertical

Example

This example adds a crisscross pattern to the interior of cell A1 on Worksheet one.

Workbook.Worksheets[1].Range['A1', 'A1'].Interior.Pattern := xlPatternCrissCross;