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?

Please Login or Register  to view this content.