Mirror

Add a page break to an Excel worksheet (Views: 710)


Problem/Question/Abstract:

How to add a page break to an Excel worksheet

Answer:

If WS is your worksheet:

{ ... }
Excel.ActiveWindow.View := xlPageBreakPreview;
WS.HPageBreaks.Add(WS.Cells.Item[78, 1]);
{ ... }

<< Back to main page