You can have 1026 horizontal pagebreaks per sheet.

If you need more than that, then you can't use Data|Subtotals. But that limit
occurs if you add them by hand or by using code like Gord posted.

Maybe you could copy data to different worksheets, put in the pagebreaks there
(how ever you decide), print those sheets and then delete those sheets.


And if you really have mostly 3-4 rows per group, maybe a separate sheet really
isn't the best use of paper.

You could double up the size of the rows to make it look like each group is
double spaced from the previous group.



cs_vision wrote:

The problem is I have over 3900 records in my database and I need to insert
manual pagebreaks for each change unit numbers. There is a limitation with
pagebreaks.

"Dave Peterson" wrote:

I find the easiest thing to do is to use Data|Subtotals.

There's an option to put each group on its own page--and I get subtotals on top
of it!

cs_vision wrote:

Can I automatically insert pagebreaks at certain points in a Excel Worksheet.
I have a worksheet that contains a column where there are unit numbers and I
need to insert a pagebreak whereever the unit number changes.

--

Dave Peterson


--

Dave Peterson