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