Excel Forum
Similar Content
Dynamic Named Range in Excel
Tutorial: How to create a named range that expands automatically when a new value is added to the r...
Print Specific Pages in Excel
Macro: This free Excel macro allows you to print a pre-specified selection of pages from Excel. T...
Dynamic Formulas that Update When you Add Data in Excel
Tutorial: I'll show you how to make formulas and functions that automatically update when more data...

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.