Hi Jim,
Need a litle more information, please.
Is there a column from which we can determine when a deal changes? In other
words, does column A look like this:

Deal1
Deal1
Deal1

Deal3
Deal3
Deal3
Deal3

........

And does this column have one or more headers rows?

If the above is correct, do you want to insert a page break after every 12
deals, not mattering whether there are three or four rows per deal?

--
Ken Hudson


"jim.casagrande" wrote:


I have a set of nearly identical worksheets that contain upwards of
2,000 rows containing information on mergers & acquisitions. Each deal
contains 3 or 4 rows of data, seperated by a blank row in between. 90%
of these deals take up 3 rows. the other 10% take up 4 rows. What I
have to do now, manually, is set page breaks every 12 deals.

I tried to record a macro by starting at B11 (the first blank cell
below the header) and using Ctrl + the down arrow 24 times to capture
12 deals (whether they are 3 or 4 rows), then hitting the down arrow
once more to be below the 12th deal, then left arrow once to highlight
column A, then alt, I, B to set the page break.

This works for the most part, except when that pattern leaves the
cursor right below a page break that is already there. Then the alt,
I, B removes the page break.

I know there is a way to clear page breaks, but i'm not sure how to do
it. Also, is there an easier way to program this in VBA? If i was
inserting a page break every 36 lines it'd be easy, but the number of
rows varies.

Any input would be greatly appreciated.

Thanks,
--Jim


--
jim.casagrande
------------------------------------------------------------------------
jim.casagrande's Profile: http://www.excelforum.com/member.php...o&userid=32987
View this thread: http://www.excelforum.com/showthread...hreadid=528156