E
Elfego Baca
I have a worksheet with 10 columns and 1 to 100 rows depending on the
number of clients we have in a day. I would like to write a macro that
automatically figures out the print size necessary and prints the sheet
or sheets necessary to print all the information. For example suppose
that on day 1 the last row with data is row 20. Since the sheet will
print 30 rows per page, then the print size would be A1:J30. If,
however, the number of rows used on day 2 is 49, then pressing the
[Print] Button (that would run the macro) would print 2 sheets; the
first with the first 30 rows and the second with the final 19 rows.
number of clients we have in a day. I would like to write a macro that
automatically figures out the print size necessary and prints the sheet
or sheets necessary to print all the information. For example suppose
that on day 1 the last row with data is row 20. Since the sheet will
print 30 rows per page, then the print size would be A1:J30. If,
however, the number of rows used on day 2 is 49, then pressing the
[Print] Button (that would run the macro) would print 2 sheets; the
first with the first 30 rows and the second with the final 19 rows.