Print each worksheet to printer of same name

[zakasnak]

I have a workbook with 150-some-odd sheets, each with a store number. I would like to loop through each sheet & print that sheet to the printer with the same name in my printers & faxes queue.

(eg. sheet 9604 would print to printer name oki9604)

Is this possible?

Thanks for any help you can give me!

 

[zakasnak]

I finally got to run my first real go of this code. It worked GREAT.

BrianB, if you're out there I would like to know if I can set a sheet to print (a memo) before the store sheets. This static sheet would need to be selected to print along with the store sheet.

Love the code, thank you so much!

P.S. If BrianB isn't available & somebody else wants to take a stab at it, please, give it your best shot! :D

TGIF... & Happy Memorial Day.

 

[BrianB]

Same as any other code. Add what you want afterwards.
Start with the macro recorder & go from there.