Moving Horizontal PageBreak
 

I try to move the location of a horizontal pagebreak (HPageBreak) to a
new location by following statement:

Worksheets("Document").HPageBreaks(1).Location =
Worksheets("Document").Range("A67")

This first pagebreak on the sheet is located at Range("A70") and should
be moved three rows up to Range("A67") by that statement.

It does not work as expected. The effect: The value (!) of A67 is
copied to A70, so both cells have the same text. The pagebreak is not
affected.

What's wrong with the statement I use? It's quite the same as the one
found in online help when searching for "location".


--
CptGreenwood
------------------------------------------------------------------------
CptGreenwood's Profile: http://www.excelforum.com/member.php...o&userid=27864
View this thread: http://www.excelforum.com/showthread...hreadid=473696

Moving Horizontal PageBreak
 

I tried this a few months back and couldn't do it with the Location method
either (It looks as though it is a read-only property.)

I had to use the delete and add methods to make it work. It didn't work the
"well" as I couldn't tell "programatically" which page break (by range) I
was deleting.

For example

Worksheets("Sheet1").Hpagebreaks(1).delete
Worksheets("Sheet1").Hpagebreaks.Add .Range("A3")

Works
But I couldn't determine that Hpagebreaks(1) was really the pagebreak I
wanted to delete (Other than knowing that my particular app only had one!)


Perhaps someone can straighten both of us out.

Lt

"CptGreenwood"
wrote in message
news:CptGreenwood.1wh3mb_1128589555.2741@excelforu m-nospam.com...

I try to move the location of a horizontal pagebreak (HPageBreak) to a
new location by following statement:

Worksheets("Document").HPageBreaks(1).Location =
Worksheets("Document").Range("A67")

This first pagebreak on the sheet is located at Range("A70") and should
be moved three rows up to Range("A67") by that statement.

It does not work as expected. The effect: The value (!) of A67 is
copied to A70, so both cells have the same text. The pagebreak is not
affected.

What's wrong with the statement I use? It's quite the same as the one
found in online help when searching for "location".


--
CptGreenwood
------------------------------------------------------------------------
CptGreenwood's Profile:
http://www.excelforum.com/member.php...o&userid=27864
View this thread: http://www.excelforum.com/showthread...hreadid=473696