Ignore page breaks for hidden rows

T

T Kirtley

Is there a way to ignore page breaks in hidden rows when printing? When I
hide rows that contain page breaks a blank page still prints (except for the
print titles).

I'd rather not use any vba since the security settings of the many users
often block the macros.

Any suggestions?

TK
 
D

Dave Peterson

Maybe you can copy the visible rows to a new worksheet--apply the page breaks
that you need and print from there.
 
Top