That would do.

InsertNameDefine will have a Print_Area name.

Just change the "Refers to:" range to the dynamic range formula constructed
from the example at Debra's site


Gord

On Wed, 23 Jul 2008 14:52:12 -0700 (PDT), Spiky
wrote:

On Jul 23, 4:00 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Assuming "chart" is just a range of cells on a worksheet, perhaps a Dynamic
Print Range will do the trick.
How do you make it a print area? Just name it Print_Area?