Hi All:

I am trying to create a log for a client, which when they hit a button
inserts a new record at the top of the page and everything is working
fine except when they try to print it, one page can hold 3 full records
but when they enter the 4 th record it gets divided, so one half of the
record is on one page and the second part is on the second page.

I need a way to force a page break after 3 records in every page. Also
when it inserts new records it automatically creates a blank page at
the end.

If anyone can help me on this issue, it would be great.

Sue


--
sue74
------------------------------------------------------------------------
sue74's Profile: http://www.excelforum.com/member.php...o&userid=21685
View this thread: http://www.excelforum.com/showthread...hreadid=381375

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