How do I set a macro to print variable number of pages in excel?

G

Guest

I have a worksheet that calculates total nuber of packages of a consignment;
I am now trying to run a macro that would print as many labels as the total
number of packages, which could be as little as one or as much as 50. I
tried to copy and paste into the pages box of the print screen, but it didn't
work.
Does anybody have a solution? The excel version is Office 2000.
Thanks
 
H

Henry

Livio,

Put the print instruction in a for-next loop.
If the number of packages is in, say Cell T6 then:

For PrintRun = 1 To Range("T6").Value
Print a label
Next PrintRun

Henry
 

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

How to extract the number of pages in a cell (Excel 2003) 3
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
How do I print faster? 3
Number of pages in worksheet doesn't match Print Preview pages 2
How to assign PRINT option to execute a macro 3
Print preview/page set-up is printing 100's of blank pages 2
need a print macro to print only a certain number of pages 2
Excel2000:How to link Print Area with a named range 5

Top