Best Way to Set Print Area So That It Includes Any Row Inserts

[Susan J]

I am pretty proud of the enclosed file but, end user is concerned about having to set the print area for each project. Is there a way I can simplify that for him?


http://www.2shared.com/file/2bwiSgPQ/CVR-Test_2012_12_08.html

 

[Hui]

Susan_J


Set a Named Formula on the test page which will be:

Print_Area =INDIRECT("$A$1:$X$"&19+MAX(TEST!$A:$A))

It uses the maximum number in Column A tom define the length of the page

The other way to do it would be to count the entries in Column A like:

Print_Area =INDIRECT("$A$1:$X$"&17+Counta(TEST!$A:$A))

 

[Susan J]

Thanks very much for this, Hui. It works and I so appreciate your help.