Macro for printing

**Dave7554** · 12-13-2009, 09:35 PM

I am new to VBA programing. I am creating a macro in Excel 2003 to print multiple copies. Specifically, I want the number of copies to be equal to the value located in a certain cell in the worksheet. Any advice?

The Excel printer code looks like this.

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

**teylyn** · 12-13-2009, 09:46 PM

Hi Dave7554,

welcome to the forum. I'm sure one of the VBA wizards will pick up your question soon.

In the meantime, please have a look at the forum rules to get a feel for how this forum is run. Please try to avoid words like "help" in the title of your thread. Since everyone asking here is looking for help, words like that don't add value.

If you want to post more than one line of code, make sure to use code tags like this [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]. That will make code easier to read and copy for testing.

I'm sure you'll find lots of valuable assistance here, so please stick around..

cheers

**broro183** · 12-14-2009, 05:01 PM

hi Dave7554,

Welcome to the forum

Try something like this...

Please Login or Register  to view this content.

Edit: Note there is no error checking in my example to make sure that the value in the specific cell is numeric.

hth
Rob

**JBeaucaire** · 12-14-2009, 08:18 PM

Broro, what's the reason for using the MAX function with only one cell in question?

**broro183** · 12-15-2009, 04:44 AM

hi JB,

I'm not connected to a printer (& had forgotten the syntax for printpreview) so I included the max function just in case there was no value in the specific cell (which may (?) cause the code to error).
It probably can/should be checked differently using If, Iif or some other ">0" check but ".Max" came into my head first as I was typing

Your curiosity made me check my facts & the Excel 2007 Help file states

The number of copies to print. If this argument is omitted, one copy is printed.

(I'm assuming this hasn't changed since earlier versions). With this in mind, there probably isn't the need for .max or another >0 check, only for a numeric check.

Rob