MrExcel Publishing
Your One Stop for Excel Tips & Solutions

not such a toughie...


Posted by Cory on August 23, 2001 1:59 PM

A have a macro that adds page breaks in certain places on my sheets (every 57 rows). It works good except it doesn't reset the older pagebreaks, just adds the new ones. In my case i need to change the pagebreaks, not just add more. Is there a way to do this? I've been trying to figure this one out for two weeks and I'm about ready to scream!

Thanks

Cory


Posted by Barrie Davidson on August 23, 2001 2:09 PM

Place this before your code to set the page breaks.

ActiveSheet.ResetAllPageBreaks

Barrie

Posted by Cory on August 23, 2001 2:19 PM

Totally awesome, Barrie!

Thanks for saving the little hair I have left :-D

Cory