Add text at the last row printed

[pantakos]

Hello,

I have a worksheet that collect data from various worksheets and insert them at a worksheet.
I need when I press print , a text that is in another sheet to be placed at the last printed page.
i.e. if the print is 3 pages then then text wil be placed at the bottom of the 3rd page. If 2 pages then at the bottom of the 2nd page etc.
I want the text to be placed at the bottom of the page and not right after the last filled row. (if the text is lets say 5 lines at the last 5 lines of the last printed page).

Thank you in advance

 

[pantakos]

Also posted here under my other account How to force text to print at the bottom of the last page of an excel

 

[RoryA]

No, you just need to provide links to your cross-posts (the rules are the same in pretty much all excel forums).

 

[pantakos]

Also posted at How to force text to print at the bottom of the last page of an excel and Add text at the last row of the last page of what is printed - OzGrid Free Excel/VBA Help Forum

 

[6StringJazzer]

Cross-posting is allowed but you are required to post a link so you don't have people duplicating effort.

 

[pantakos]

Update! Finally I will do that with footers using this code
ThisWorkbook.ActiveSheet.PageSetup.LeftFooter = or RightFooter etc.

Thank you all for your effort and time wasted !
Cheers!