G
Guest
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
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