| 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 | |||
Linear Mode
