I am trying to adjust the page breaks by code and as for the vertical page break I used this recorded line
Code: Select all
ws.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
How can I delete all the vertical page breaks and let only one vertical break before column L?
I tried this
Code: Select all
ws.VPageBreaks.Add ws.Range("L1")