can I have a cell in my worksheet to control the number of copies.

I want to create a cell in excel to input the quantity to print so I don't
have to go to 'File' Print to put the quantity. Is that possible

If you use a macro to print

Sub PrintBook()
Activeworkbook.PrintOut Copies:=Activeworkbook. _
Worksheets(1).Range("A1").Value
End Sub

--
Regards,
Tom Ogilvy

"1google" <[email protected]> wrote in message
news:[email protected]...
> I want to create a cell in excel to input the quantity to print so I don't
> have to go to 'File' Print to put the quantity. Is that possible