Setting one page break per row

required_username · #1 02-01-2017, 07:00 AM

This should be easy but I can't find the answer. I want to have one record (one row) on a page. I can't find how to do this.

W8 / Excel 10

jolivanes · #2 02-03-2017, 08:04 PM

Try this. Change references as required.

Code:

Sub Set_Page_Breaks_Every_Row()
Dim c As Range
For Each c In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row + 1)
    c.PageBreak = xlPageBreakManual
Next c
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Page Break is adding Blank Page when Break occurs	JoannL54	Word	3	07-01-2016 05:58 AM
How to add page numbering after next page break with landscape and portrait	Jashley1	Word	2	11-25-2014 10:36 PM
Removing space before blank page / page break	greasel	Word	5	10-17-2014 07:04 PM
First section will not 'insert' blank page even though sectn 2 is 'odd' page break	Pat_Hodgson	Word	6	12-01-2013 04:22 PM
Section Break (Next Page) replaces Section Break (Continuous) when deleted	Carlabasson	Word	2	03-25-2013 10:13 PM