ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert Row without affecting page breaks (https://www.excelbanter.com/excel-programming/405124-insert-row-without-affecting-page-breaks.html)

PMC1

Insert Row without affecting page breaks
 
Hi,

I'm using a procedure that performs multiple tasks amoung which is
insert rows in various sections of a worksheet. This causes a problem
where a particular sheet is broken up by manual or automatic page
breaks. I want to insert rows without affecting the location of
horizontal page breaks anywhere in the sheet.

Is this possible and if so have you any suggestions on code?

I'm using Excel 2003.

Thanks

Paul


All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com