i have an application that prints production line information. i use an array to
filter and print each production line's item list. this works fine when one copy
is printed. when 2 or more copies are printed, it puts both copies of production
line 1 together, line 2 together and so on. so the client has to manually sort
through and group all 8 production lines into 1 report.

my question is:

is there a way i can print the entire range (no filter) and have excel divide
the production lines (the production line number is in column V) so the next
production line always starts a new page?

this way i could print and keep all 8 production lines together.
--


Gary