Printing a certain amount of pages based on amount of data
 

Hi,

I am using a macro to add data to a worksheet. I want to print the
sheet afterwards, but only enough pages to print all of the data plus
an additional 40 rows or so, for additional written input. How can I
do this?

To take this a stage further, I would like to add a given amount of
pages, the same formatting as those with data but just containing
blank rows. How do I make these full pages as opposed to a page and a
half of formatted workspace and then blank unformatted space?

kind regards,
Matt