sujittalukde
07-26-2007, 10:07 PM
I am using a code for subtotal at page break. THe code doesnot show the Brought forward at the top of each page but shows Page subtotal at the end of each page.
I have another macro (Please note that this one also not made by me) which inserts a row below the page subtotal to be displayed at the top of each page as "Brought Forward"
But the problem is that when the row "Brought forward" is inserted, page break disturbs and as the "Page subtotal" and "Brought forward" does not appear at the bottom and at the top of the page.
Can these two macros be combined to generate the desired output - that is "Page Subtotoal" will come at the bottom of each page and Brought forward to appear at the top of each page?
Attached Wb shows the page subtotal code and Brought Forward code.
I have another macro (Please note that this one also not made by me) which inserts a row below the page subtotal to be displayed at the top of each page as "Brought Forward"
But the problem is that when the row "Brought forward" is inserted, page break disturbs and as the "Page subtotal" and "Brought forward" does not appear at the bottom and at the top of the page.
Can these two macros be combined to generate the desired output - that is "Page Subtotoal" will come at the bottom of each page and Brought forward to appear at the top of each page?
Attached Wb shows the page subtotal code and Brought Forward code.