Replace Cell Value From Range Then Print Worksheet

**BillyRaySpivy** · 02-01-2017, 01:24 PM

Hello all,

I want the value of cell D4 to be replaced one at a time from the list of ID numbers if greater than zero (I6:I28) then the worksheet printed each time. I have set the print area for the worksheet already.

Is this possible to do with a macro?

Thank you very much for your help

**Arkadi** · 02-01-2017, 02:21 PM

Hi BillyRaySpivy,

Give this a shot:

Please Login or Register  to view this content.

**BillyRaySpivy** · 02-01-2017, 02:50 PM

Okay I tried it. What happened was the print popup showed quickly I think 4 times but only the first sheet actually printed.

**Arkadi** · 02-01-2017, 03:08 PM

I ignored your button, had to clear code in a module because it is not in a sub and wouldn't let code run. Pated my code in Module3, and ran it, got 4 printouts. I assume the issue has to do with your printer or printer driver, try adding a delay between printouts...

Please Login or Register  to view this content.

**BillyRaySpivy** · 02-01-2017, 03:17 PM

Wow that works fantastic! There is one more request please if possible. On my worksheet I have a column L for Check. Could this code also put a checkmark showing they were printed?

**Arkadi** · 02-01-2017, 03:52 PM

Ok try this, I changed the code to check if I is > 0 and also check to see if there is a checkmark already in L before printing

Please Login or Register  to view this content.

**BillyRaySpivy** · 02-01-2017, 03:55 PM

Perfect! Thank you very much for the support. Have a great rest of your day.

**Arkadi** · 02-01-2017, 03:56 PM

Thanks, you too! Thanks for marking the thread as solved, and the rep

**Arkadi** · 02-06-2017, 11:02 AM

BillyRay,

Odd, I just noticed I made a mistake putting the delay OUTSIDE the loop so it should not have made much difference, the code below fixes that, but maybe you don't need the wait command at all... test with it removed. You will have to set the correct password in this code, but it should fix the error when you protect the sheet (code just unprotects to start and then protects it again).

Please Login or Register  to view this content.

Replace Cell Value From Range Then Print Worksheet

LinkBack

Thread Tools

Rate This Thread

Display

Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Re: Replace Cell Value From Range Then Print Worksheet

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] for each row in range print worksheet with data from row

[SOLVED] Setting print range for large worksheet

Scan barcodes, replace cell with next one after print action

Copy cell data from worksheet 1 to worksheet 2 - run macro to create and print document

VBA to set print range, open box asking for print qty, print, then redefine print area

Code to print a range of cells in a worksheet.

[SOLVED] Can you get the range reference for each page in a worksheet print range?

Bookmarks

Bookmarks

Posting Permissions