In my workbook, I have hundreds of rows that are automatically hidden/unhidden based on various cell values. Some of these hidden rows contain hard page breaks, which I need to keep for whenever those rows are not hidden. When I print, the hidden rows are generally excluded, but I still get a blank printed page for every hard page break. Can I configure Excel to ignore hard page breaks when they are located within a hidden row? Or maybe I need a VBA code to remove the hard breaks when the row is hidden, but add them back when the row is unhidden?