Add Page Breaks Between Charts VBA

Hello,

I have an Excel sheet that has a chart beneath rows of data, followed by more data, and another chart, repeat this x10.

I need to clear all page breaks and then add page breaks before and after each chart. The number of rows between each chart changes daily so I can not use a specific row as my page break.

Any VBA help with this will be GREATLY appreciated.

try

Please Login or Register  to view this content.