Reference>TXLSHPageBreaks>Add

Adds a horizontal page break. Returns an TXLSHPageBreak object.

Syntax

function Add(Before: IXLSRange): TXLSHPageBreak;

Before

IXLSRange. A Range object. The range above which the new page break will be added.

This example adds a horizontal page break above cell G15 and adds a vertical page break to the left of this cell.

With Workbook.Sheets[1] do 
begin
  HPageBreaks.Add(Range['G15', 'G15']);
  VPageBreaks.Add(Range['G15', 'G15']);
end;