Hello,
Is there an easier way to shorten the code to select and preview multiple worksheets in a workbook. I have about 60 worksheets and want to select 50 of them to preview - below is sample code I'm using:
Sheets("Smith").Activate
Sheets(Arry("Smith", "Todd", "Fisher", "Quick", "Blown", "Jones", "Wayard")).Select
ActiveWindow.SelectedSheets.PrintPreview
I actually have about 50 worksheets I'm referencing to select all of them and preview them using a button.
Thanks much.
MAB
Bookmarks