Data Row falls out of Page Break Area

[ed_z]

Hi guys, I have an excel macro which inserts data to an existing table as a new row. However I realised that the new row inserted is always out of the page break area. Is there any way around this? As this may cause my users to miss on on information not under the page break area.

[Gregor y]

if you were inserting at row 177, then it should automatically push the page break down, but it'd also push the "old data" on that line down too.

you could also reset the PrintArea after the insert or better yet after all the inserts

Please Login or Register  to view this content.