Detecting Page Breaks in Excel

The saga continues...

Now I'm trying to write a program to automate filling out an Excel spreadsheet...the problem is that the sheet is multiple pages and the first 9 rows contain header information for when the sheet is printed. Skipping down 9 rows and continuing is no problem, but detecting where the page break is...well, is.

So, how can I detect where a page break, either hard or soft, is, and whether or not the row I'm on is the row immediately preceding the break?

Me and my boss both say thanks for any help in advance.

try this, no need to check for page breaks.

Moved to Office Development.