Automated Dynamic Printing Area?

[smplogc]

Is this possible?

Say you have a 200 row spreadsheet with various functions being performed in the bottom cells. If only the first few rows are filled with data, when printed, all the empty rows that won't fit on on the first page will automatically be omitted, except for those important bottom rows. So the first page will have the rows filled with data, plus empty rows to fill out the page, and the bottom rows.

If there are one too many filled rows to fit on one page, then a second page will be printed with enough empty rows to fill the page, with the bottom rows included at the bottom of the second page.

In other words, I want print jobs to be scaled in terms of pages based on filled rows, with important bottom rows automatically added at the end of the last page of the job.

[starguy]

you can do this by hiding empty rows in between your data rows. you can do this very quickly by using commands.

first select your data range which you want to print (from top to bottom).
then File > Print Area > Set Print Area

now when you want to take print Just apply following commands.
click on cell in row next to your entered data.
press Ctrl+Shift+Down Arrow Key (it will select all blank rows to last row which has functions).
Now hold only Shift key and press Up Arrow. It will deselect the row which has data (Functions).
Now press Ctrl+9 (nine below F8 not on numeric key pad), it will hide your empty rows.
and at last press Ctrl+P to print the document.

It seems long process but it is't so. It take just 3 to 5 Seconds to take a print. (because I used to do this on regular basis)

[smplogc]

Thanks for the reply.

The problem is that my spreadsheet will be used by very computer-illiterate people, and I'd like to make tasks as simple and fool-proof as possible.

[PY & Associates]

You must know how many lines your print page holds;
You must also be able to count the rows one way or another;
then you can do what you want.

"smplogc" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks for the reply.
>
> The problem is that my spreadsheet will be used by very
> computer-illiterate people, and I'd like to make tasks as simple and
> fool-proof as possible.
>
>
> --
> smplogc
> ------------------------------------------------------------------------
> smplogc's Profile:
http://www.excelforum.com/member.php...o&userid=33887
> View this thread: http://www.excelforum.com/showthread...hreadid=537072
>

[smplogc]

You must know how many lines your print page holds;
You must also be able to count the rows one way or another;
then you can do what you want.

Hehe, yup, but I don't know how to implement that in VB code or whatever method would do the trick.

[PY & Associates]

Hehe, I say "tips", but you guys do all the work!

"smplogc" <[email protected]> wrote in
message news:[email protected]...
>
> PY & Associates Wrote:
> > You must know how many lines your print page holds;
> > You must also be able to count the rows one way or another;
> > then you can do what you want.
>
> Hehe, yup, but I don't know how to implement that in VB code or
> whatever method would do the trick.
>
>
> --
> smplogc
> ------------------------------------------------------------------------
> smplogc's Profile:
http://www.excelforum.com/member.php...o&userid=33887
> View this thread: http://www.excelforum.com/showthread...hreadid=537072
>