![]() XLastrow = xWs.Range("A1").SpecialCells(xlCellTypeLastCell).Row XRow = Application.InputBox("Row", xTitleId, "", Type:=1) VBA: Insert page break in every X rows in a worksheet. In the window, click Insert > Module to show a new module window, then copy the following VBA code into the module window. Press Alt + F11 to display the Microsoft Visual Basic for Applications window.Ģ. ![]() Here I will insert a page break in every 3 rows.ġ. Maybe you are not familiar with VBA running before, but with the follow steps you may know how to run the VBA to insert a page break every X rows.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |