Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select Quantity Printing
I want a macro to print a worksheet with the provision to user define the
number of copies thank you Mald |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select Quantity Printing
the printout command has a copies argument. You can query the user for the
number of copies, then pass that as a variable to the printout command copies argument. -- Regards, Tom Ogilvy "Mald" wrote in message ... I want a macro to print a worksheet with the provision to user define the number of copies thank you Mald |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select Quantity Printing
pCnt = InputBox("How Many Copies") ActiveWindow.SelectedSheets.PrintOut Copies:=pCnt, Collate:=True -----Original Message----- I want a macro to print a worksheet with the provision to user define the number of copies thank you Mald |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select Quantity Printing
thanks tom
"Tom Ogilvy" wrote: the printout command has a copies argument. You can query the user for the number of copies, then pass that as a variable to the printout command copies argument. -- Regards, Tom Ogilvy "Mald" wrote in message ... I want a macro to print a worksheet with the provision to user define the number of copies thank you Mald |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select Quantity Printing
thanks
" wrote: pCnt = InputBox("How Many Copies") ActiveWindow.SelectedSheets.PrintOut Copies:=pCnt, Collate:=True -----Original Message----- I want a macro to print a worksheet with the provision to user define the number of copies thank you Mald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
Select Printing Macro | Excel Discussion (Misc queries) | |||
Printing during select times | Excel Programming | |||
Select other workbook to select data in a macro. | Excel Programming |