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

Hi Jordan2322,

Here's an old one of mine - you'll want to experiment with the orientation and the lines per page:

Please Login or Register  to view this content.