Forum Discussion
a88139g
Nov 25, 2020Copper Contributor
Page Break Preview Help
Hi, I want to shift my page break preview automatically and consider anything I type in area outside page break. How can I do it. As in picture attached my page break is not automatically shifted after I entered text in E6 cell.
2 Replies
- NikolinoDEPlatinum Contributor
dynamic Page break show with VBA:
Sub N_Lino() Dim WS As Worksheet: Set WS = ActiveSheet For i = 1 To WS.HPageBreaks.Count Ad = WS.HPageBreaks(i).Location.Address If Not IsEmpty(Range(Ad).Offset(-1)) Then Range(Ad).End(xlUp).PageBreak = xlPageBreakManual End If Next i End SubInsert, move, or delete page breaks in a worksheet
View page breaks
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
- a88139gCopper ContributorIs it possible without VBA?