Dont'want page breaks in union of ranges

[fuzzyangel]

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?

 

[SkipVought]

Hi,

Hide row 6 and use A3:BN7 as the Print range

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}