i don't know the correct syntax (which you might be able to get from
those other posts you read), but how 'bout

start @ row 1
go down (what? 50 rows?)
if row is empty, insert page break
if row is not empty, then
range.end(xlup) to beginning of area/group.
offset up once more, & that should be your first blank
line previous to the expected page break.
if row is empty, insert page break.
go down 50 rows again, etc.
yes, it looks like it would all have to be based
on column c.

susan


On Jan 24, 1:35 pm, liz25mc wrote:
Hello!
I've read and reread the page break posts and can't find what I need.
I have a spreadsheet list of items that are split into groups ie:

Column A Column B Column C
5 1234-566 Brown
5 Brown
5 Brown
Then a blank row
5 1235-555 Green
5 Green
5 Green
Then a blank row etc.

There might not always be three rows before the blank. I need a macro that
will add a page break but not break up the set of three if it falls at the
end of the sheet. I am thinking the page break will need to be based on
Column C, somehow, but I am not sure how to go about it. Any help would be
appreciated.
Thanks.