Page break for every Nth visible 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.

[karedog]

Maybe :

Please Login or Register  to view this content.

[morbdetro]

I was finally able to have time to test this and the code works perfectly! Thank you for the help.

[karedog]

You are welcome, thanks for marking the thread as solved and for the rep. points.


Regards