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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Location
On Mar 8, 2:31 pm, Geoff wrote:
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 Hi location is a range object. The default property of a range object is its value, so your line Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5") assigns the value in Range("e5") to the range object Worksheets(1).HPageBreaks(1).Location as you said. If you want to add a horizontal PageBreak you must add it to the HPageBreaks collection Worksheets(1).HPageBreaks. Add and give a location for it. You can also delete an item from this collection Worksheets(1).HPageBreaks(1).Delete You can't move a page break as such. regards Paul |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Break Location
Hi
I appreciate that now. Any idea why the small case for HPageBreaks.location ? It doesn't seem to make a difference. Seems similar to pages within a Multipage ie Multipage1.page1 rather than Multipage1.Page1 Geoff " wrote: On Mar 8, 2:31 pm, Geoff wrote: 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 Hi location is a range object. The default property of a range object is its value, so your line Worksheets(1).HPageBreaks(1).Location = Worksheets(1).Range("e5") assigns the value in Range("e5") to the range object Worksheets(1).HPageBreaks(1).Location as you said. If you want to add a horizontal PageBreak you must add it to the HPageBreaks collection Worksheets(1).HPageBreaks. Add and give a location for it. You can also delete an item from this collection Worksheets(1).HPageBreaks(1).Delete You can't move a page break as such. regards Paul |
Reply |
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 |