Creating a Page Break Macro for Dynamic Data

[MacrosforArtemis]

Hello!

I am creating financial reports (populated by uploaded data) and would like to write a macro to insert a page break; however, where the page break should be can change month to month. Is there a way to write a code in such a way that it will not break a 5-line grouping up?

For example, all my segments are:

Header 1
Revenue
Expense
Net Income
{blank line}

At different months, the automatic page break may cut between Revenue and Expense or Expense and Net Income, all depending on how many segments were active that month. I need the macro to read these groupings and if a segment is divided, insert a page break prior to the header.

Everything I can find either sets the page break at a certain word or after a certain number of lines which I cannot utilize for this issue. Is this macro possible?


Sample Picture.png

[mjr veverka]

What is the determinant of breaking the page, some signature e.g. "PB" in the column next to or something else, or page can be broken anywhere, but not across the segment ?
It would be better if it was a table/array.

[ikboy]

Try this:

Please Login or Register  to view this content.

[jolivanes]

Attach a file that people can work with. I find it very difficult to run code on a picture. Mention the maximum amount of rows you want for each print page and if you have any print titles or not.
https://support.microsoft.com/en-gb/kb/210663
I don't know if the problem mentioned in above article has been fixed or not.

[jolivanes]

Forgot to ask.
Why do you need Page Breaks. You can print ranges without setting page breaks.
I assume that you want to print these areas.

[jolivanes]

So which code did you go with?

[MacrosforArtemis]

Thank you all for your input - after testing, we decided to go a different route due to the nature of the data warehouse.

[jolivanes]

Thank you for the update. Good luck and if you need any Excel Help, you know where to come to.