How to add page break when a cell changes to existing macro

[jeffkab]

Hi All,
I'm having a lot of trouble figuring this out and was wondering if anyone can help. I have a macro that creates formating to a report that is based on input from a message box. I'm trying to find a way to insert a page break whenever the cell differs in column B and starting 1 row after the first merged cells. I have found a standard way to do this but I need to find a way to do this after that first merged cell. If it helps the merged cell will always say ASAP1. Any help would be much appreciated!!
Thanks!!

 

[Perksy_no1]

HI there,

I had a problem with setting pg breaks in a macro which http://www.mrexcel.com/forum/member.php?93657-ZVI helped me with. I had to set the pg breaks when the word total was found so perhaps you could agjust the code he write for me to suit your needs. Link to thread http://www.mrexcel.com/forum/showthread.php?631158-Setting-Pg-breaks-using-VB

hope this helps??

 

[jeffkab]

Thanks Perksy, that helped!

 

[Perksy_no1]

no probs glad to help