Find a header and loop until the last header

[Ada01]

i have a reprt that comes out of accounting software and is a long and unorganized.

I need a macro that finds the word "brown" (part of a header at the top of every page) and inserts a page break - repeating until the last "Brown" is found.

I have been trying the "do, loop while" loop for this, but have not gotten it to work

Thanks

[shg]

Why not put the header in the sheet header?

[Leith Ross]

Hello Adao1,

Try this macro...

Please Login or Register  to view this content.

Sincerely,
Leith Ross