Excel Page Break Every 35 Rows with VBA - 2457

У вашего броузера проблема в совместимости с HTML5

Tina C asks if there is a better way to add a page break every 35 rows. Way back in episode 360, I showed a few methods. But today, one line of VBA in the Immediate Window seems much easier. You have to edit this line in three places:
For i = 37 To 1446 Step 35 : ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Cells(i, 1) : Next

My courses on the Retrieve Platform are at: https://mrexcel.retrieve.com/store/#/