Hi nickjar2,
The only apparant workaround for your situation is to hide the rows between your two ranges, using code such as:
Rows("19:84"

.Select
Selection.EntireRow.Hidden = True
Fortunately in your situation, your ranges are above/below each other. In other situations where the ranges are "disjointed" - i.e. in totally separate columns, or on separate sheets, it becomes IMPOSSIBLE to include the two ranges on ONE page. As you have experienced, Excel "FORCES" a Page-Break between the two ranges.
This has been a LONG-STANDING BUG with Excel. I have attempted SEVERAL times to get Microsoft to fix this BUG once and for all, but to no avail. Interestingly, the competition, Lotus 123 has NEVER had this problem or restriction. And, the solution for Microsoft is probably no more difficult than changing a "1" to a "0", or eliminating the line of code which forces the page break.
This forced page break should logically NEVER have been included in the first place, as it offers NO benefit. It makes perfect sense to LEAVE IT UP TO THE USER as to whether a "forced page break" is required, and the option has always been there to insert a forced page break if required.
Perhaps what Microsoft requires is for readers of this forum to "FORCE THE ISSUE" with Microsoft - by forwarding a copy of this item to Microsoft, or whatever other option readers might suggest.
Bottom line on this is, this BUG has been a "thorn" in the side of MANY Excel users for FAR TOO LONG, and needs to be KILLED. So, readers, PLEASE HELP OUT, and Microsoft, PLEASE "LISTEN TO YOUR USERS".
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca