Page Breaks in Excel

BAMeyer

New Member
I've not been able to find any examples of inserting page breaks in an Excel spreadsheet using Progress.

If anyone has done this or has any suggestions, I would appreciate the help.

Bruce Meyer :confused:
 
I don't remember how can you ? I mean in Excel not thru Progress.

You tell me and I'll tell you how to do it with Progress.
 
To make a horizontal page break:
excelAppl:range("E25"):rows:PageBreak = xlPageBreakManual. /* -4135 */

To make a vertical page break:
excelAppl:range("E25"):columns:PageBreak = xlPageBreakManual. /* -4135 */

To clear a vertical page break:
excelAppl:range("E1"):columns:PageBreak = xlNone. /* -4142 */

Simon
 
Back
Top