![]() |
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 |
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