smcgee8806
New Member
- Joined
- Feb 3, 2010
- Messages
- 1
I'm hoping someone can help me with this. I have a report that groups items under specific headings. Each heading may contain a different number of items beneath it and the rows are not all the same height. Is it possible to create a macro that will automatically insert a page break based on the following conditions:
1) maximum number of rows on each page, but
2) page break is always above the next heading (in this case when the value of column F=1) ????
In other words I want to get as much data as I can on each page, but I do not want any of the groupings to be split between two pages. Hopefully someone can help.
Thanks.
1) maximum number of rows on each page, but
2) page break is always above the next heading (in this case when the value of column F=1) ????
In other words I want to get as much data as I can on each page, but I do not want any of the groupings to be split between two pages. Hopefully someone can help.
Thanks.
