Not if someone wants to invest the time to write a solution for you. It
certainly isn't a trivial undertaking.

--
Regards,
Tom Ogilvy

"DKY" wrote in message
...

So, in other words my situation is hopeless?

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

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

--
Regards,
Tom Ogilvy



--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=271517