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

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=57129