Excel/VBA - Custom print range problem
Hi all,
I have a worksheet that i need to print sections of.
I always need to print range(B3:K3)
the rest of the information i need to print would be from B:K, but different
rows, always in a block.
for example
print: B3:K3 and B20:K45
print: B3:K3 and B14:K22
when i select these two ranges and print them, they are 'separated' on the
printed page. (the further down the secondary range is, the more space/blank
pages there are)
is there any way to get B3:K3 to be printed on top of the secondary range
like a column header.
i thought about setting the page header to B3:K3, but I already have a page
header that i can't change.
any thoughts/suggestions?
tia!
J
|