How do I set Auto Print Area?
sounds alright,
but how do I put the formulla in there, can u give a little more
explanation, or an example please.
"Spiky" wrote:
Oh, I see.
Make a print area. Go into Names:Define. Select the Print_Area name
and change its reference. Something like:
=INDIRECT("Sheet1!$A$1:$G$"&Sheet1!$H$1)
So it will print the columns through G and the rows through whatever
number is in H1. And then you put a formula to figure out the last row
in H1. You may be able to just plug that formula into the Name, as
well.
|