Printing sheets based on data within a sheet.

  • Hello,

    I have a spreadsheet with a number of tabs. One of the tabs has numerous pages that will not be needed all the time. Is there a way I can have Excel only print specific pages within a tab as well as all other tabs. Setting the print area does not work as I will need to print page 1 and 4 and 7, but not pages 2,3,5 or 6. I have attached a copy of the file, and the tab I am referring to is "Weighed Chemical Tags." Thank you!

  • Possibly work around...

    Sub Print_Out_Pages()
        Dim s As String, v As Variant, c As Variant
        s = Application.InputBox("Enter page numbers, separated by commas", Type:=2)
        v = Split(s, ",")
        For Each c In v
            ActiveWindow.SelectedSheets.PrintOut From:=c, To:=c
        Next c

    If I've been helpful, let me know. If I haven't, let me know that too. 

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!