Ajimieta
04-25-2017, 11:50 PM
Hello everyone, I am a new comer in this forum and also beginner in Excel VBA.
Currently, I'm in the midst of preparing the Template for company invoice and DO. So I like to ensure some common row (such as Total Amount, Signature column) always at the bottom of the printed page, and also on the last page, because Invoice/ Do can be multiple pages due to many items to be listed. Try to use HPagebreak, but I am not really understand about it.
Please find attached the sample of the invoice and perhaps can explain what I am looking for.
Case 1: Condition when on One page only
Case 2: Condition when Multiple page (2 pages)
Currently, I'm in the midst of preparing the Template for company invoice and DO. So I like to ensure some common row (such as Total Amount, Signature column) always at the bottom of the printed page, and also on the last page, because Invoice/ Do can be multiple pages due to many items to be listed. Try to use HPagebreak, but I am not really understand about it.
Please find attached the sample of the invoice and perhaps can explain what I am looking for.
Case 1: Condition when on One page only
Case 2: Condition when Multiple page (2 pages)