ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Page Break Test (https://www.excelbanter.com/excel-programming/314427-page-break-test.html)

Datasort

Page Break Test
 
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


Tom Ogilvy

Page Break Test
 
http://groups.google.com/groups?thre...%40tkmsftngp05

--
Regards,
Tom Ogilvy

"Datasort" wrote in message
...
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





All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com