D
Dan Wasser
(Sorry for being so lengthy or confusing.)
I have a 290-line spreadsheet of all of the items that my
company sells. My 5000-line macro filters out
the "unsold" items (and performs various cosmetic
functions) so that I end up with a "clean," printable
version of only the sold items to send to my customer.
There are different categories/sections (of items) in the
printout and, frequently, one of the categories starts at
the bottom of the first page and then continues on the
second page. Each of the sections/categories have
a "title." But when one of the categories (usually
it's "Future and Additional Fees") is continued on the
second page, I want to be able to put a title at the top
of the second page (the title would be "Future and
Additional Fees, continued" for example). I'm already
using the "rows to repeat at top" (in page setup) for my
logo. I guess my question is: how can my macro determine
if and when a second page occurs (because, sometimes, the
result is only one page long) and then, when/if there is a
second page, which category is printing at the bottom of
page one but continues on page two, and where (what is the
appropriate line?) can I put the appropriate "title" at
the top of page two (beneath my logo) but before the rest
of the items?
I have a 290-line spreadsheet of all of the items that my
company sells. My 5000-line macro filters out
the "unsold" items (and performs various cosmetic
functions) so that I end up with a "clean," printable
version of only the sold items to send to my customer.
There are different categories/sections (of items) in the
printout and, frequently, one of the categories starts at
the bottom of the first page and then continues on the
second page. Each of the sections/categories have
a "title." But when one of the categories (usually
it's "Future and Additional Fees") is continued on the
second page, I want to be able to put a title at the top
of the second page (the title would be "Future and
Additional Fees, continued" for example). I'm already
using the "rows to repeat at top" (in page setup) for my
logo. I guess my question is: how can my macro determine
if and when a second page occurs (because, sometimes, the
result is only one page long) and then, when/if there is a
second page, which category is printing at the bottom of
page one but continues on page two, and where (what is the
appropriate line?) can I put the appropriate "title" at
the top of page two (beneath my logo) but before the rest
of the items?