Before And After The Pagebreak

Feb 5, 2009

I need to copy two rows and then insert it so the first row will be before and the second row will be after each pagebreak untill there is no more data in the spreadsheet.

The rows to be copied and inserted are together (row 1 and 2) and I can locate the rows in the same sheet or in a different one (as easy as it could be).

View 9 Replies


ADVERTISEMENT

VBA Expression To Insert Pagebreak

Oct 29, 2008

Here's what I need to do. I have a list of row numbers in AA2:AA6, so for i =1 to 5
I want to insert a page break before cell (column AA and Row(#in cell AA2-5))

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved