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: 4
Default Printing multiple ranges w/o page breaks between

Hi
I used VBA (I use Excel 5) to select two regions of a worksheet.
The first is some headers (cells a3:bn5) and
the second is one region (cells a7:bn7) that includes
what I want to be printed.
So I use union to selected these two regions.
But in print preview (hence in the printout) the first range (the
headings) is printed separately from the other region.
How can I get rid of these page breaks?

 
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
Printing, Scaling, Page Breaks Erin Searfoss Excel Discussion (Misc queries) 1 March 28th 08 12:02 AM
Page Breaks- Printing selected rows on same page ToddEZ Excel Discussion (Misc queries) 1 July 18th 07 04:38 PM
Printing Prob: Uncontrolled page breaks after every row [email protected] Excel Discussion (Misc queries) 0 November 21st 06 04:51 PM
How can I do one-time printing without set page breaks? kewlblondboy Excel Discussion (Misc queries) 2 August 24th 05 02:53 PM
Printing multiple ranges on one page Adella Excel Programming 1 May 4th 04 04:49 PM


All times are GMT +1. The time now is 05:37 PM.

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

About Us

"It's about Microsoft Excel"