Excel page break between Table & Range

dotsent

Board Regular
Joined
Feb 28, 2016
Messages
89
Office Version
  1. 365
Platform
  1. Windows
Hi!

I got a page break challange in Excel (2016) worksheet. I have a defined table containing statement of account ("Table1") - the table is autoexpanding and populated with a copy-paste function over VBA. The table area is followed with a signature area which is not changing, but taking several rows of space on its own. I had to define the signature area as range ("Range1") as otherwise table autoexpansion would clear off a few purposeful empty rows between the table and signature area (hence the signature range begins with a few empty rows).

The issue I'm trying to tackle - I need to implement a page break so that the signature area "Range1" wouldn't be broken down to different pages on printout should the "Table1" expand so much that the entire signature range wouldn't fit in the same page.

I see there are some basic page break settings available where I can pinpoint a specific row where to break the page, however I don't think they are applicable here given that I'd want to break the entire range. Using VBA to do this would be fine, but great if there's a native function for that.

Thanks a lot for any ideas!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top