Thread: Macro to select Quantity Printing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mald Mald is offline
external usenet poster
  
Posts: 6
Default 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 With QuoteReply With Quote