Hi Todd,
I always do something that looks similar to the following:
xlSheet.HPageBreaks.Add(xlSheet.Rows(lnRowNumb + 1))
where 'xlSheet' is an object refering to a specific excel sheet, not the whole application. What that's saying is to add a horizontal page break before the row listed between the '()'. You can do 'VPageBreaks' too, but then you must specify a column in the '()' instead of a row.
Paul A. Busbey
Victoria Insurance