Print range & a different sheet as a single print job.

[bhsoundman]

I'm trying to combine a print job of defined range of cells on one sheet with an entire other sheet. I've gotten to a point where a single macro prints the defined range, then once that print job is done, it prints the other worksheet. I just want to combine them so I can print to a single pdf file. I can already print an array of sheets, but the first area is not a sheet.

 

[jolivanes]

Programmatically hide the cells that do not need to be printed so all you will have left is the "defined range of cells".

What works also is to have the font white for what should not show up when printed.

 

[jolivanes]

Sub Test()
Dim fRange As Range
    Set fRange = Application.InputBox(Prompt:="Select the Rows you don't want printed with the mouse", Title:="Selection required", Type:=8)
        fRange.EntireRow.Hidden = True
    ActiveSheet.PrintPreview
End Sub

Hold down the Ctrl key if you need to select non contiguous rows