Change Vertical page breaks in Excel spreadsheet preparing to print
Looks like we have to access PageBreakPreview BEFORE we can change them
ActiveWindow.View = xlPageBreakPreview
Set ActiveSheet.VPageBreaks(1).Location = Range("Z2") ' Column after the break
Set ActiveSheet.VPageBreaks(2).Location = Range("AS2") ' Column after the break
ActiveWindow.View = xlNormalView
' And to change horizontal break use HPageBreaks
Views 679
Downloads 216
CodeID
DB ID
ANmarAmdeen
602
Revisions
v1.0
Wednesday
February
24
2021