I am able to use a print code to print selected tabs from an Excel workbook:
Code:
Sub PrintTest()
Application.Dialogs(xlDialogPrinterSetup).Show
Worksheets(Array("Sheet1", "Sheet34")).PrintOut
End Sub
[code\]
What I would like to do is look at a list of tabs in a worksheet and print those tabs. For example, there might be a "Print_Page" tab with a list of 15 tabs that I would like to print. How can I say in the VB code to look at the sheet Print_Page and, say, cell A2, which would have the name of the tab I would like to print? Ideally, I would like to be able to print A2:A15.
Thanks