"leonidas" ha
scritto nel messaggio
...

Hi,

I have a question about always printing a group of rows on the same
page.
I have a worksheet with data in rows 12 tot 246. The user can insert
numbers in column J. When printing, the rows with an empty column J
will be hidden and only the rows with a number in column J will be
printed. Below row 246 there is an empty row and then there is a group
of rows (248 to 269) which I would like to allways print on the same
page.

Problem is the group of rows above can vary, because the user can
insert or not insert numbers in column J. I know I can insert a
pagebreak at row 247 so the group of rows (248 to 269) is allways on a
new page, but then it is possible that I have an allmost empty page and
then the page with the group on it. I would like to prevent that too.

Can someone help me with creating a macro? Thanks in advance!




Hi Leonidas,

I think this could be a good starting point for you:

http://exceltips.vitalnews.com/Pages...ge_Breaks.html

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy