I have code provided by a fellow user that works when printing a list of tabs in cells. For example, the tab called "PrintPage" has a list of tabs from G12:G15. The following code works to print those tabs:
Sub printShtsTEST()
Dim Ary As Variant
Application.Dialogs(xlDialogPrinterSetup).Show...