Printing blocks of cells on a page

Hello there,
I am trying to devise a macro that will print blocks of text without overlapping to the next page.

Does anyone have a set of instructions that will achieve this? None of the commands to reset page breaks, hard page breaks, clear print area etc seem to work!

Thanks in anticipation.

Allan THompson