Dave,
This one is acting up on me. . .
Regarding setting the print area to adjust to the last column with
visible data.

I'm using a series of formulas to summarize data that appear on
different tabs.
In cell D4, is the place to place the tabs name, and then in cells
5-12 are formulas that appear something like this:

=IF(ISERROR(INDIRECT(D$4&"!$B$1")),"",INDIRECT(D$4 &"!$B$1"))
this loads the contents from cell B1 from the tab entered in the
summary sheet (cell D4).
So far, so good.

I've also got conditional formatting that instructs excel to present
blank and empty cells in rows 5-12 if D$4 is blank.

Theoretically with the named ranges, the size of the page will adjust
to the number of tabs I'd like to see data on and that have a value
entered in the various columns in row 4.

(Rows 1-3 are just banner rows, with project data.)

So far, the print area still goes all the way out 52 columns(where
there are formulas but no data as row 4 is empty out there. . .)

Could you have a 2nd look at the named range references(below), and
recommend any adjustments?

Thanks for any and all. (Hope I didn't break any rules by posting a
mini-novel.)
Pierre



Lastcol
=LOOKUP(2,1/(Summary!$1:$1<""),COLUMN(Summary!$1:$1))
lastrow
=LOOKUP(2,1/(Summary!$C$1:$C$2000<""),ROW(Summary!$C$1:$C$200 0))
summaryprintarea
=OFFSET(Summary!$A$1,0,0,lastrow,lastcol)