VBA Dynamic Page Break to retain a range when printing

Hi, I am looking to create a dynamic page break that ensures about 20 rows are not split into separate pages when printing (summary of an estimate). I already have a button created that the user presses which selects the desired rows to print so that the user doesn't print the whole sheet (there are columns to the left and right that we don't want printed). I want to incorporate VBA code that inserts a page break if needed to keep cells together but doesn't insert it (and deletes if one exists from a previous print) if the cells are already going to print on the same page (aka don't have an unnecessary page printed). I know how to insert the page break and delete the page break, but I don't know how to check if an automatic page break will occur between the two named cells on my spreadsheet.

Here is what I have so far:

Please Login or Register  to view this content.