in reply to Re^4: Help inserting page break in Microsoft Excel using OLE
in thread Help inserting page break in Microsoft Excel using OLE

I finally figured it out! You can not replace "ActiveWindow -> SelectedSheets" with "$sheet." Instead, you use this:

$excel -> ActiveWindow -> SelectedSheets -> HPageBreaks -> Add({Before => $sheet -> Range("6:6")}); This inserts a page break before row six. Thank you anyway to those who looked at my problem.
  • Comment on Re^5: Help inserting page break in Microsoft Excel using OLE

In Section Seekers of Perl Wisdom