Is it possible to determine if a row is set for a page break? The
ActiveSheet.HPageBreaks item collection does not seem to be working. I have
even tried to go into print preview mode then out about. I can't seem to
determine were the next print row would be placed.

The ultimate problem is I am trying to print a banded report from a
database. I have a header of X rows with a band repeating an unknown number
of times. I would like to put a pagebreak before a band is broken up.

Also note that the page footer is dynamic, I am not able to expect that the
footer will take up the same amount of space each time.

I have tried working with the ActiveSheet.HPageBreaks item collection. I am
not able to get it to refresh b/c it is missing cells where breaks are
located. It looks to me like there are hard breaks and soft breaks.

Thanks in advance,

Stewart Rogers