How to set the page breaks for printout

[Tom Ogilvy]

Turn on the macro recorder and insert a pagebreak manually.

Turn off the macro recorder.

then look at the recorded code. That should get you started. Just be aware
that if the page will only hold 66 rows (as an example), placing a pagebreak
at row 70 (again as an example) will not keep it from pagebreaking at row
66. If this sounds obvious, it doesn't seem to be for many.

 

[Konrad Viltersten]

While one can use the interface of Excel to set up the
partition of the page breaks manually, it's not a great
secret that it's a major pain in the lower back.

I was wondering - how can one programatically set
where the page breaks will occur. Is it doable at all?

After Googling the matter i realized i'm not going to
find the answer there (i'm not sure what to look for
in terms of search words). So, any suggestions?

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------

 

[Konrad Viltersten]

I was wondering - how can one programatically set

Turn on the macro recorder and insert a pagebreak manually.
Turn off the macro recorder.
then look at the recorded code. That should get you started. Just be
aware that if the page will only hold 66 rows (as an example), placing a
pagebreak at row 70 (again as an example) will not keep it from
pagebreaking at row 66. If this sounds obvious, it doesn't seem to be for
many.

Thanks.

--
Vänligen
Konrad
---------------------------------------------------

Sleep - thing used by ineffective people
as a substitute for coffee

Ambition - a poor excuse for not having
enough sence to be lazy
---------------------------------------------------