I have VBA code to print a particular print range in my worksheet - the range is specific to a department's need to print that range and not any other range in the same worksheet. In addition, there are checkboxes in a different worksheet that when checked or unchecked will hide or display a particular range of grouped rows. Because I have hard page breaks built into the VBA print code, the hidden rows are printed as blank pages. How do I write code to ignore the page break if the rows are hidden?
Sub PrintEBank()
'
' PrintEBank Macro
'
'
Range("A7:N146").Select
ActiveSheet.PageSetup.PrintArea = "$A$7:$N$146"
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Worksheets(1).Range("a27")
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Worksheets(1).Range("a43")
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Worksheets(1).Range("a63")
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Worksheets(1).Range("a91")
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Worksheets(1).Range("a118")
ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=Worksheets(1).Range("a139")
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:="pdfFactory Pro", Collate:=True, _
IgnorePrintAreas:=False
End Sub
Bookmarks