View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel/VBA - Custom print range problem

in page setup on the last tab, set "Rows to Repeat at Top" to row 3.

--
Regards,
Tom Ogilvy

"Gixxer_J_97" wrote in message
...
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