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!
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!
