B BAMeyer New Member Dec 15, 2005 #1 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
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
joey.jeremiah ProgressTalk Moderator Staff member Dec 16, 2005 #2 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.
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.
I it@flude.co.uk Member Dec 16, 2005 #3 To make a horizontal page break: excelAppl:range("E25"):rowsageBreak = xlPageBreakManual. /* -4135 */ To make a vertical page break: excelAppl:range("E25"):columnsageBreak = xlPageBreakManual. /* -4135 */ To clear a vertical page break: excelAppl:range("E1"):columnsageBreak = xlNone. /* -4142 */ Simon
To make a horizontal page break: excelAppl:range("E25"):rowsageBreak = xlPageBreakManual. /* -4135 */ To make a vertical page break: excelAppl:range("E25"):columnsageBreak = xlPageBreakManual. /* -4135 */ To clear a vertical page break: excelAppl:range("E1"):columnsageBreak = xlNone. /* -4142 */ Simon