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
- Matrixman
- Closed
-
-
-
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 -
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!