Custom print area's and fill page

[Voittaja]

Hi smart guys,

First of all let me compliment you on the answering and problemsolving you offer here.

Next for my question:
I have a large spreadsheet with lots of data already divided in certain parts. I managed to set pagebreaks in the print preview on the exact places I want. What I like to see is that all pages are spread out (stretched) to fill an exact page. How can I manage this (maybe through VBA)? I tried to construct a macro in which I managed to find the location of the pagebreaks. But after that I am lost.

Greetz,
Victor