Page break on visible rows with set amount of rows

**gizmo1** · 11-27-2022, 07:37 AM

Hello,

I need to be able to set a page break on visible rows only. The first page break needs to happen after the 63rd visible row, then every 49 rows that are visible after that for the report to print correctly. Thank you in advance for any help you can offer.

Steve

**ByteMarks** · 11-28-2022, 12:52 PM

Does this work for you?

Please Login or Register  to view this content.

**gizmo1** · 11-28-2022, 02:39 PM

Awesome! Works great, thank you very much

Page break on visible rows with set amount of rows

LinkBack

Thread Tools

Rate This Thread

Display

Page break on visible rows with set amount of rows

Re: Page break on visible rows with set amount of rows

Re: Page break on visible rows with set amount of rows

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add page break after every 48th rows + border after last row on page

Select visible range and add page break after every 20th visible cell

Need VBA Code to Ignore Hidden Rows Page Break (Rows Grouped/Ungrouped)

Trying to count rows from manual page break to manual page break

[SOLVED] Page Layout (Page Break Preview) is not working with hidden rows in excel.

[SOLVED] Setting a Page break for every 20 rows

[SOLVED] Conditional page break if merged rows won't fit on the page.

Bookmarks

Bookmarks

Posting Permissions