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:
However, if I try to print a list of tabs from C12:C15, I get an error saying "Printout method of sheets class Failed." I have no idea why changing the column causes an error when it's the exact same code, just pointing to a different column (C instead of G). Does anyone know what I'm missing?
Rich (BB code):
Sub printShtsTEST()
Dim Ary As Variant
Application.Dialogs(xlDialogPrinterSetup).Show
WithSheets("PrintPage")
Ary =Application.Transpose(.Range("G12", .Range("G" &Rows.Count).End(xlUp)).Value)
End With
Sheets(Ary).PrintOut
End Sub
However, if I try to print a list of tabs from C12:C15, I get an error saying "Printout method of sheets class Failed." I have no idea why changing the column causes an error when it's the exact same code, just pointing to a different column (C instead of G). Does anyone know what I'm missing?
Last edited: