So, in other words my situation is hopeless?

Tom Ogilvy Wrote:
The code does nothing with pagebreaks. You would need to determin
where
the pagebreaks are on each insertion and then see how many rows need t
be
inserted if there is a problem. This would need to be done from th
first
row to the last row and you are moving from the last to the first, s
you
would probably need to do that in a separate loop.

You could just put in a pagebreak at each change in part number. D
you
want to do that?

--
Regards,
Tom Ogilvy


--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=27151