How can a macro select "all" tabs (or specific ones) without having to write in each tab name? My tab names might change, so I'd like to be able to select them all, or select sheets #2-6, 8, 11-21, etc., and print?
Thanks much!
Printable View
How can a macro select "all" tabs (or specific ones) without having to write in each tab name? My tab names might change, so I'd like to be able to select them all, or select sheets #2-6, 8, 11-21, etc., and print?
Thanks much!
worksheets can be refered to by index as well as by name
Moved to Office Development.
VB Code:
Sheets(Array(1,3,5,7,8)).Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
So simple! Thanks!