Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Location
VB Help says:
The following example changes the location of horizontal page break one. Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5") (From that I would expect Location to return a range address.) The example does not change the physical location of the page break for me at all. Instead it puts the value of E5 put into the automatic page break cell, in my case, A63. If I want to get an address returned I have to use: Worksheets(1).HPageBreaks(1).location.Address or .Row And that is the other thing, .Location becomes .location, small 'l' when I type it in. These are small things but they prevent confidence in developing what I am trying to do - manipulate page breaks around variable row data. Can anyone explain please T.I.A. Geoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
page break location in VBA | Excel Programming | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
What is the location of my first horizontal page break? | Excel Programming |