Print Qty of Excel Sheets = cell value macro

January 7, 2011 at 14:10:01
Specs: Windows XP
Hello,

I need help with a print macro. I have a file with multiple tabs (each tab having unique information) including a data entry tab. On the data entry tab, I want to put a button that will allow me to print a specific number of pages from each tab based on a specific cell value on that tab.

For example: Cell M1 on each tab will contain a number. That number represents the number of pages to print.

Tab 1: M1 = 2
Tab 2: M1 = 5
Tab 3: M1 = 3

The print button should then print 2 pages of the data on tab 1, 5 pages of the data on tab 2, and 3 pages of the data on tab 3.

Can anyone help me with the macro needed to do this?

Thank you,


See More: Print Qty of Excel Sheets = cell value macro

Report •

#1
January 7, 2011 at 17:23:10
How are you defining what a "page of data" is?

Are you letting Excel figure out where to put the page breaks or are you printing specific number of rows or something else?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question