Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant move pagebreak in PageBreak View in Excel2003 | Excel Worksheet Functions | |||
INSERT HORIZONTAL PAGEBREAK AFTER EACH LINE IN ENTIRE WORKSHEET . | Excel Worksheet Functions | |||
MANUAL & AUTOMATIC Horizontal Pagebreak Report - an example | Excel Programming | |||
Manual Horizontal Pagebreak Report - an example | Excel Programming | |||
moving automatic vertical pagebreak | Excel Programming |