Printing Multiple Sheets that have a Specified Selection

[Excel"*"]

Hi All,

I'm using the following code to print a specified selection on a sheet, it works great. But now, I was to be able to use this code on 3 sheets and print all of them @ once.

Here is the code for the sheet.

Please Login or Register  to view this content.

Ideally, I could add another sheet called Retail GM into this code so when the user prints it would print both sheets while maintaing the selection.address part. That is very critical.

Any thoughts? Thanks for everyone's help in advance.

[Excel"*"]

Thoughts Anyone?