Pagebreak when range does not fit

[leonidas]

Hi,

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

Problem is the group of rows above can vary, because the user ca
insert or not insert numbers in column J. I know I can insert
pagebreak at row 247 so the group of rows (248 to 269) is allways on
new page, but then it is possible that I have an allmost empty page an
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

 

[Franz Verga]

"leonidas" <[email protected]> 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/T0787_Conditional_Page_Breaks.html

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy