Variable Print Length

  • Thread starter Thread starter Elfego Baca
  • Start date Start date
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.
 
Elfego,

By "Print size" do you mean the Print Area? Normally, it's not necessary to
do anything special to print a large or small worksheet. Just Print. It
prints it on as many pages as necessary.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printer selection in VBA 1
Excel Populate Delivery Note 0
Print titles must be contiguous and complete rows or columns 3
Creating a print-macro that'll only print page 1? 2
Printing a large/long spreadsheet on legal size paper problem 1
Hiding row if first cell is empty (VBA) 1
Macro for deleting rows and serialising the remaing rows 1
Hide Print Unhide 1

Back
Top