HotXLS Docs
Home Contents Overview

Location property

Returns the cell (a IXLSRange object) that defines the vertical page-break location. Read only IXLSRange.

Syntax

property Location: IXLSRange;

Example

This example sets the interior color of the page-break location to red. 

Workbook.Sheets[1].VPageBreaks.Item[1].Location.Interior.Color := xlRed;