I need to select all the sheets in a workbook so I can print them together as double sided (duplex) copies.:)
[Solved] VBA: Code to select all sheets in a workbook
See if you can adapt Dave's code in the SheetstoPrint.zip example here
Thanks for the link but I'm afraid that I have no idea how to use this code. The sheet does what I need and more, but I don't know how to put it in an existing module? Sorry to be so slow, but is there a more direct way to select all the sheets?
Hey guys, sorry for showing my ignorance. Checked the Analysis Collection once I got home and found what I needed. Thanks for the post RoyUK, I'll be using that add in a lot too.
Oh, by the way, here's what I was looking for.
Sheets.Select Selects all sheets in the active workbook
WorkSheets.Select Selects all worksheets in the active workbook
Charts.Select Selects all chart sheets in the active workbook
Don’t have an account yet? Register yourself now and be a part of our community!