PDA

View Full Version : How to make Total Row always at the Last Row / bottom of the Printed Page



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)