ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HPageBreak not working - More info (https://www.excelbanter.com/excel-programming/447373-hpagebreak-not-working-more-info.html)

[email protected]

HPageBreak not working - More info
 
When I use any method (in Excel or in VBA) to insert an HPageBreaks, it
goes into the collection and it works, UNLESS I have the row heights set
like I want them. Then no HPageBreak works, no matter what row I put it
on. hen the HPageBreak is still in the collection (I can find it there)
but no PageBreak actually occurs. There is no page marker on the screen
(Either the HPageBreak or automatic breaks), Print Preview does not show
the break, and when actually printed, the break does not occur.

Thanks so much for any help.

[email protected]

HPageBreak not working - More info
 
It turns out that this problem was caused by a Windows update that also
caused a number of other people similar problems. I uninstalled the
offending update and this problem went away.

I still have another HPageBreaks problem however but that's for another
topic.

On Sat, 13 Oct 2012 10:58:56 -0400, wrote:

When I use any method (in Excel or in VBA) to insert an HPageBreaks, it
goes into the collection and it works, UNLESS I have the row heights set
like I want them. Then no HPageBreak works, no matter what row I put it
on. hen the HPageBreak is still in the collection (I can find it there)
but no PageBreak actually occurs. There is no page marker on the screen
(Either the HPageBreak or automatic breaks), Print Preview does not show
the break, and when actually printed, the break does not occur.

Thanks so much for any help.




All times are GMT +1. The time now is 10:38 AM.

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