Number of Copies - Printing

**janjan_376** · 08-01-2008, 10:18 AM

Hi. I have a worksheet that I want to print # of copies base on the input value on cell d4. ie: If I put 4 on d4, then click on print, I would like to send 4copies to the printer (or print it 4x). Please help.

**VBA Noob** · 08-01-2008, 11:13 AM

Maybe

this code must go in ThisWorkbook module

Please Login or Register  to view this content.

VBA Noob

**janjan_376** · 08-01-2008, 03:14 PM

I tried it and worked perfectly. Thank you very very much. I wish I could learn this by myself.

**VBA Noob** · 08-01-2008, 03:19 PM

Glad it helped

Reading posts on forums would soon get you up to speed.

VBA Noob

**janjan_376** · 08-01-2008, 03:21 PM

I would like to put outline border on a1:c4 automatically if d4 is not empty. I tried conditional formatting but its function is just too limited. Is there a way to do it using vba ( not macro ) ? Please help. Thanks.

**VBA Noob** · 08-01-2008, 03:24 PM

You would need to start a new thread as per forum rules below

CF should work thou

VBA Noob

**janjan_376** · 08-28-2008, 10:16 AM

Hi,

Is there a VBA code to print a sheet.

Example:

I have a worksheet, sheet1 and sheet2. I would like to print A1:F100 on sheet2 after I click on Printer icon while I am on sheet1. Is there a VBA (not a macro) code to do this ?

Please help again.

Thank you very much.

**janjan_376** · 09-11-2008, 12:20 PM

Originally Posted by VBA Noob

Maybe

this code must go in ThisWorkbook module

Please Login or Register  to view this content.

VBA Noob

The code works perfectly and I really appreciated it. I would like to know how can I use this to print sheet2 when I click on print while I am on sheet1.

Thank you.