View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fuzzy fuzzy is offline
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?