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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

Copying cell contents a specified number of times 4 mail merge? 2
VBA Data Entry Window 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Access My Expression Contains Wrong number of arguments 0
Copy entire row to diff worksheet based on value 0
selecting multiple cells from multiple worksheets for printing 0
Minimising VBA Code 4
Automating a simple multiplication to a reference cell 1

Back
Top