What is the syntax for adding and End of Page marker in Excel

[Joost Kant]

Searching for the rigth syntax:

SET vRange="A45"

OBJECT CALL oExcelWorkSheet.HPagebreak.Add.vRange
or
OBJECT CALL oExcelWorkSheet.HPagebreak.Add(vRange)
or
OBJECT CALL oExcelWorkSheet.HPagebreak.Add.Range(vRange) is not the syntax.

Who can help me?

[Mikael T]

Hi Joost, this will add a pagebreak at row 15 in the worksheet.

DIM xlRow AS VARIANT, xlPagebrake AS VARIANT

LET xlRow = 15
LET xlPagebrake = %XlPageBreak.xlPageBreakManual

OBJECT LET oExcelWorkSheet.Rows(xlRow).PageBreak = xlPagebrake

Here some more information about adding pagebreaks: https://docs.microsoft.com/en-us/off...ange.pagebreak

Regards, Mikael

[Joost Kant]

Thanks Mikael