Insert Row without affecting page breaks

P

PMC1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top