how to insert page breaks for each row in excel

#How to insert page breaks for each row in excel code

I'm looking for an easier code (excel beginner/intermediate) but I'm open to any ideas. (and some sheets don't need a page break as they only have say 5 customers) (with varying i = numbers and combination) but I haven't had any success.ĭoes anyone else have any other ideas? there normally is only one page break per storenumber sheet, with the except of one sheet. Worksheets(storenumber).HPageBreaks.Add before:=Rows(start.row) I have tried doing something similar to this: If i >= 102 And start.row = 176 And start.row <= 166 Then

I had thought maybe the pagebreak could be anticipated with the row number (as that's how I'm grouping the data) but one sheet has the break on row 101 (because this data starts at row 46) and the other has the pagebreak on row 106. I am trying to come up with a code to sense whether or not the data range will be split up, but I can not. To insert the macro for say worksheet 7 then, with sheet 7 opened, I went to the tools menu -> macro -> macros -> typed in a name 'lines' -> create and pasted in your code under macro name sub lines() as it came up in the visual basics editor right window. Make sure that youre on the Sheet tab of the Page Setup dialog box. Click on Print Titles in the Page Setup group. Textwise looks like this (if picture is unavailable)īut sometimes there is a page break in the middle of a customer data, so that the title shows up on the first page but the last row(s) are on a new page. In the one workbook I have 12 worksheets, each several pages long when printed. Open the worksheet that youre going to print. I have tables (with lots more data) that looks like this: I'm trying to create a monthly report for my company and I'm having troubles with the aesthetics of it.

How to insert page breaks for each row in excel