Hi all,

I have been trying to figure out a way to have a page break set on open, x number of rows down and x number of columns over.

Now here's the tricky part.

It can only count visible rows and only print one page. Not have multiple page breaks.

Background: We have an orders report that when they ship we hide the line to "archive" it. This issue is that we have to go into page break preview and manually move the page break down the same amount of rows we hid.

I thought this would be easy and was going to use the same code for the open for a print button. In case someone whats to print out a report after hiding.

Any help would be appreciated.

Thanks!