Automatically/Dynamically Set Print Area

[rockja]

We are using a task list which has a fixed number of columns (A-F) but we are constantly adding rows. Since this is something which gets printed often, it's becoming annoying to keep setting the print area each time, not to mention there are some who keep forgetting to set the print area and print incomplete reports.

I've coded a simple counter which updates every time a new row of information is added (pasted below).

I then used the max of the counter to dynamically change the coordinates of the second formula (pasted below).

I need to figure out a way to input the second formula into the 'Print_Area' in Name Manager.

Is this possible or am I taking crazy pills?!

Thanks,
-Jason

'Counter' =IF(ISBLANK(A23)=FALSE,G22+1,"")=23
'Dynamic Table' =(CONCATENATE("A1:F",MAX(G1:G1000)))=A1:F23

 

[rockja]

Got it working... Sort of

In Name Manager, I set Print_Area=OFFSET('Task List'!$A$1,0,0,COUNTA('Task List'!$A:$A),6)

This works great until I save and close the workbook. When I reopen it, a fixed print area replaces my above formula.

Any ideas?