Print number of pages based on cell value

Hi,

Not sure if anyone can help, is it possible to print pages based on a cell value with VBA.

So if cell A1 contained “0” then 0 pages/copy’s would be printed, if A1 then contained “4” four pages would print?

.
This works with the "activesheet" .. which can be any sheet you want. Cell "A1" of that sheet must have the number of times you want
the printer to print.

Please Login or Register  to view this content.

Here is another method that allows the user more flexibility :

Please Login or Register  to view this content.

Hi Thanks for your help,

This is what I have, so the copies is cells O4 - O9, they all have different page ranged.

The print will be exercuted from sheet1, the print range is in sheet 2, the copies value is in sheet1. I have no idea why this isn't working, are you able to assist?

When running these I get runtime error 1004 Method 'range of object' '_worksheet' failed

Please Login or Register  to view this content.

.

Please Login or Register  to view this content.