Hi,

I have a worksheet with rows 2 to 9 as rows to repeat at top. Rows 10
to 246 are filled with data. These rows will be hidden when there is
nothing in column J, so this printrange can be different every time it
is printed. Also new rows can be added between rows 10 and 246.
Row 247 is empty, rows 248 to 269 are filled with data (the number of
rows is allways the same), row 270 is empty and rows 271 to 295 are
also filled with data (the number of rows is also allways the same).

When printing it sometimes happens that rows 248 to 269 or rows 271 to
295 are cut through half and appear at two different pages. Is it
possible to allways print these rows at one page? When one of both or
both fit on the previous page it should be printed on that previous
page together with rows 2 to 246.
Thanks in advance for any help!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=569809