Page Break Every Cell - VB Code Workaround

[AlInVegas]

I have a spreadsheet that comes up with the page break every cell error when I run macros that touch any of the page layout or print parameters. My understanding is that this an error that sometimes occurs when Page Scaling is used.

Has someone come up with a short sweet workaround code that resets the breaks and allows the 1 page wide by however many long to work?

 

[bobbiejo1104]

Not sure if it's related, but thought it might help.... My page layout changes to include a page break for every cell any time I print to PDF from Excel. If I close the file and exit the instance of Excel, then reopen Excel and the file in question, the page breaks go back to what I originally set.