Print Macro

Gday Guys,

Im just looking for some help with building a print macro.

I was wanting to create some logic behind the print so that the macro can determine the appropriate number of sheets to print to.

The number of rows I am wanting to print varies quite a bit whereas the columns are always fixed - A inclusive to J inclusive (Columns A:J)

I was wanting to do something along the lines of the following:

*Count the total number of rows to be printed
*from this number determine the appropriate number of sheets to print on such that the text is easily legible
*Page breaking has to occur at certain Rows that have .Borders(xlEdgeBottom).Linestyle = xlContinuous (the last row of the page has a bottom border) and preferably at the manager lines (Please see the attached workbook)

Has anyone got some code that could be helpful in helping me build this?

Kind Regards