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

jeffkab

New Member
Joined
Dec 11, 2011
Messages
14
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!!
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Upvote 0

Forum statistics

Threads
1,211,684
Messages
6,103,281
Members
447,853
Latest member
olddutch7

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top