Hi there,

Is there a macro to print pages based on the number in a cell?

I already have a formula that calculates how many cells contain data. I want a commandbutton that prints from the pages shown in two cells.

E.g.
A3 = 1
A4 = 5
When I click the commandbutton, it automatically prints pages 1 to 5.

OR

A3 = 10
A4 = 12
When I click the commandbutton, it automatically prints pages 10 to 12.

I've already got the printer set up properly, so if possible, I'd rather the print window not appear. As soon as the button is clicked, the nominated pages automatically print.