Page Breaks to avoid splitting groups

Hey Everyone,

First post to this forum...Looks like a pretty nice site!

So I have a timesheet page in MS Excel 2010 that can have 40 to 1000 lines (depending on the amount of jobs the employees worked on). I am wanting to automate setting page breaks to avoid an employee block from being split on to 2 separate sheets (which happens all the time).

I think the easiest part of this is the last line of each employee block has the value "Sum" in column "A", but the last line of a page almost never falls on line 69.(Imagine that!)

As it sits now, there is no text wrapping and row height is all equal and I'm getting 69 lines per page.

Anyone give some insight on vba to help set page breaks after the last "Sum" value in column "A" that does not run to the next page?

Thanks in advance Guys,
Vince

You can assign HPageBreaks based on the value of Range.Height. Get the row number for "SUM" rows & then compute the height to see if you can fit data for 1, 2 or 3 employees completely; & assign HPageBreaks accordingly.

Good luck
- Jewel