Find row number above specific row, then insert page break

I'm having a heck of a time figuring this out. So any help is GREATLY appreciated.

I'm essentially trying to insert a page break on a row that will change from time to time. In this report, range A22:A150 is marked as either 0,1 or 2. 0 means the line is excluded from the report, 1 means the line is included and 2 means include but it is also the last line of a previous section of the report.

If the report cuts off in the middle of a section, I need to find the row where the page break occurs (GOT THAT), then find the row with the previous "2" above that row. Then insert a horizontal page break below that line. I have tried all kinds of methods and I'm just getting nowhere. This is where I am at currently:

Please Login or Register  to view this content.

Try something like this...

Please Login or Register  to view this content.

Originally Posted by mvparker79

It tells me the page break row, but then I get a "Type Mismatch" error on the set rng2 line.

I edited the "A22:A150" range in the original post, try it again.

You're welcome. Glad it worked.