Require an automatic "fittopagestall" that checks for data

[habsfan1433]

Hi all,

Right now I'm working with an excel sheet that allows user to input data from rows 9 to 90, which have been formatted with gridlines. I have a macro that checks how much data they have put in on the sheet and prints only the data:

Please Login or Register  to view this content.

What I would like to do is a sort of automatic fittopagestall that will print gridlines until the end of the page, even if there is no data.

ex.: A page is 10 rows of the table. A user enter 24 lines worth of data.
current result: Two full pages are printed with the data, then 4 rows are printed on the third page with the data the user put in, the rest of the page is blank.
desired result: Two full pages are printed with the data, then 10 rows are printed, 4 containing data and the rest blank for users to hand-write more data after having printed.


Thanks in advance to anyone that has a suggestion!

[davesexcel]

Try something like this?

Please Login or Register  to view this content.