Excel Forum

Excel Magic Trick #215: Dynamic Print Range

See how to create a named formula with OFFSET & COUNTIF functions that defines a Print Area, and then insert the formula name into the Print Area Name.
Create A Dynamic Print Area.

See Name Manager 2007 (Define Name 2003)

Got a Question? Ask it Here in the Forum.