S Susan J New Member Dec 9, 2012 #1 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
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 Excel Ninja Staff member Dec 9, 2012 #2 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 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))
S Susan J New Member Dec 10, 2012 #3 Thanks very much for this, Hui. It works and I so appreciate your help.