Excel Page Break (HPageBreak)

HCL Domino Domino Forum
1

I’ve tried many incantations in order to insert a page break into an Excel spreadsheet.The VB macro statement is…

ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell

How do I convert this to LotusScript?

Thanks,

Neil.

2

Subject: Excel Page Break (HPageBreak)

I had the same problem. I figured out the following code which worked for me.With Sheet 'Define the sheet object before

Set ma = .Range(“A49”) 'dim ma as variant

.HPageBreaks.Add ma

End With