I have a report that has rows that do not need to be shown at all times. To accomodate this, I have a column with a True/False formula, and a macro that goes through all rows and hides those rows where the formula is false. This part works just fine, each row is hidden/unhidden in a fraction of a second. The problem comes after I either print, preview, or change the print settings. Then it takes 3+ seconds for each row to hide/unhide. This happens whether I run the hide/unhide macro or if I manually hide/unhide the rows.
Any ideas? I've never seen anything like this.