Make sure you don't have any manual page breaks in that range (even in the
hidden columns).

And make sure your set the print to only one page wide (or one page tall??).

GoFigure wrote:

Does anyone have a, or some, suggestions? I'd appreciate any.

Many thanks,

- Al

GoFigure Wrote:
Perhaps I'm not coding this correctly. I have tried your sugestion, Tom,
but it still results in all the columns in the range, including the
hidden ones.


Code:
--------------------
Sheets(sThisSheetName).Columns("B:J").Hidden = True ' Hide Jan - Mar
Sheets(sThisSheetName).Columns("M:U").Hidden = True ' Hide Apr - Jun
PA_PrintRange = "$K10:$W52" ' K:L = Q1 totals and V:W = Q2 totals
--------------------


This results in two pages:

- Page 1 - Q1 totals, Apr, May, June
- Page 2 - Q2 totals


- Al

--
GoFigure
------------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...fo&userid=4274
View this thread: http://www.excelforum.com/showthread...hreadid=493043

--

Dave Peterson