View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gixxer_J_97[_2_] Gixxer_J_97[_2_] is offline
external usenet poster
 
Posts: 206
Default 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