Page break for every Nth visable row

[morbdetro]

Hello all. I have a macro that am using to help generate inventory count sheets from a master sheet. I would also like to be able to use this to reprint 2nd count sheets from the same data set. The code I am using works perfect for generating the first count sheets. What I would like to be able to do is after data entry and filtering out the items that do not need recounts, rerun this code to reinsert page breaks but skipping the hidden rows. Any help would be awesome.

Please Login or Register  to view this content.

[6StringJazzer]

Duplicate, probably caused by server error.

http://www.excelforum.com/excel-prog...sable-row.html