I produce an Aged Debt file report for company representatives. I would like to organise the file such that each section (representative) has an even number of pages for printing back to back and distribution to the individuals.
The number of pages initially is variable so when a representative has actually an odd number of pages I need to insert a blank page to prevent the double sided printing mixing the data for two reps on the same sheet of output.
I am using the following code to generate subtotals for each representative
and wondered if there was some way to incorporate my requirement here.
I guess the "PageBreaks:=True" part of the code actually throws to the head of the next page after subtotalling, so when the page count to this point is an odd number it throws a blank page?
Any help much appreciated.
The number of pages initially is variable so when a representative has actually an odd number of pages I need to insert a blank page to prevent the double sided printing mixing the data for two reps on the same sheet of output.
I am using the following code to generate subtotals for each representative
Code:
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(6, 7, 8, 9, _
10, 11, 12), Replace:=True, PageBreaks:=True, SummaryBelowData:=Trueand wondered if there was some way to incorporate my requirement here.
I guess the "PageBreaks:=True" part of the code actually throws to the head of the next page after subtotalling, so when the page count to this point is an odd number it throws a blank page?
Any help much appreciated.
