Print loop using one template

[ceramist_2079]

Hello all,

hope all is well, i need help by creating a VBA loop printing using one template. all of the information is on another tab. On this tab, users can select cells for printing. Also, i want to be able to choose a particular printer and input number of copies needed. thanks in advanced.

file attached

Jeff

[protonLeah]

Please Login or Register  to view this content.

Columns H & J on DONCASTER should be hidden.

[ceramist_2079]

your trick has done wonders. thanks very much.

regards,

jeff