LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to select and print custom data (eg: cell value) in excel head Ned Excel Discussion (Misc queries) 1 April 12th 06 08:50 PM
print problem custom paper size Henry Excel Discussion (Misc queries) 0 February 27th 06 08:26 PM
Excel 2000 VBA - Set Print Range in dynamic range sub_pop[_5_] Excel Programming 2 July 27th 04 08:01 PM
Problem selecting a range to print... usa1 Excel Programming 3 June 16th 04 01:07 AM
Custom Addin, Excel Shutdown Problem RodT Excel Programming 4 April 15th 04 06:14 AM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"