Any one have some code that will manually add page breaks but not break a
table across two pages? I've created some code that creates about two dozen
pivot tables in a vertical format. I'd like to use VBA to do the same as I
would if I looked at the sheet in PageBreak Preview mode and slide the auto
breaks up to the next break.

I don't want to add a break after every table since some are small.

Thanks - John