Hi

I have a worksheet that has a print area determined by the result of a formula in column B. If the formula returns any information to those cells then the print area increases down the sheet.

All is working well with this but id like to include a range of cells (including data, totals and a further calculation on those totals) at the bottom of the printout. So far my endeavours result in these cells always printing on a separate page. Can anyone advise please?

The print area is determined using the below formula -

=OFFSET(Invoice!$B$1,0,0,Invoice!LastRow,50)

I did try adding the selection of cells after this but it results in them always printing to page 2.

=OFFSET(Invoice!$B$1,0,0,Invoice!LastRow,50),Invoice!$B$859:$AY$879


thanks