I am trying to set a horizontal page break within a large VBA program (more than 100 pages of macros). The code I am using is:
Cells(x,1).Select
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:= ActiveCell
This does not work in my Excel program, but if I run the page break macro on...