Page Break Location

[Geoff]

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

 

[paul.robinson]

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

 

[Geoff]

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