Conditionally Delete Row and Place Page Break

[XLHead]

Hello,

I'm trying to write a macro that looks through Column A, finds any cell with the word "Page Break", deletes that row, and adds a Horizontal Page Break in its stead. Also, since there are already incorrect Horizontal PageBreaks, is there a way to take those out while keeping the good ones (from the macro) in? Can anyone help me?

Thanks a bunch in advance! =D

John

[Palmetto]

See if this works for you. Unfortunately, there is no way to know what is a "bad" page break. This code will remove all existing page breaks and then insert them as you specify given the work "page break" in a cell.

Please Login or Register  to view this content.

[XLHead]

Hi Palmetto,

That was great help - thanks so much! The final code ended up being this:

Please Login or Register  to view this content.

I opted to hide the row instead of deleting it since another macro I have uses the "...Page Break..." as a reference as well.

Thanks again! =D

[Palmetto]

Glad to have been of help.

If you are satisfied with your solution please mark this thread as solved by going to the top of your first post and clicking on Thread Tools, then Go Advanced and choose the [SOLVED] prefix.

Thanks for posting your complete solution. Others will benefit from it.