One way would be to loop through your sheet after the new record ha
been found and every time it finds the end of a record then increment
counter.
Use an If statement to check when the counter = 3 and the The
statement will insert a page break.

It wasn't clear if you wanted an extra blank page at the end of you
printout or if you are getting an undesired blank page

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38137