Printing Worksheet Multiple Times

[grah2002au]

Hi,

I have a project which works a little like a mail merge in that the same sheet is printed multiple times with particular data updated each time between prints. ie. a series of job cards where I update the job# and description of works, print then update with the next job# and description print and so on through a list downloaded from the mainframe.

Currently I print the sheet after each update which takes an inordinate amount of time to cycle through especially when printing 100+ jobcards in a run.

Is there any way to spool the print after each update and then send the entire print run once only at the end of the run to the printer ?

If someone could provide the applicable VBA code or the modifier to the existing code I have created by recording the macro as i printed manually, it would be hugely appreciated.

Cheers,
Marty

[funkymonkUK]

looks like you need a loop.

send me your file and I will see what I can do.