I am looking for help with this print macro to be modified. It currently prints all active tabs but I need it to Print tables 1-3 and last active tab. there will be additional tabs added so I don't want it to print tables 4-... but does include the final active tab.
Any help making this happen would be great. Here is the macro that I am currently using which is great but need t be adjusted to exclude the sheets descried above.
![]()
Sub PDFprint() ' ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Replace(ThisWorkbook.FullName, ".xlsm", ".pdf"), OpenAfterPublish:=True End Sub
Bookmarks