Hi all,

I have a form that has a print button on it. When the button is clicked it prints a range of cells where there is a 'booked in' date but no 'booked out' date for particular ID numbers. When i print the page it starts a new page every time it sees a page break. This would be ok if i were printing the whole sheet but my selection for printing may end up being, for example, rows 1 & 2 where row 2 is below a page break after row 1. this means that i get the first row on 1 page and the second row on another page.

Anyone know how to stop this happening?

Thanks,
Spinkung.