Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subscript Out of Range ... Setting Page Breaks
Hi,
I recorded the macro below. But when I run it I get a "subscript out of range" message. I would welcome any suggestions. Sub Macro1() ' ' Macro1 Macro Sheets("Variance").Select ActiveSheet.ResetAllPageBreaks Set ActiveSheet.VPageBreaks(1).Location = Range("AA1") Set ActiveSheet.HPageBreaks(2).Location = Range("A397") Set ActiveSheet.HPageBreaks(3).Location = Range("A389") Set ActiveSheet.HPageBreaks(2).Location = Range("A332") Set ActiveSheet.HPageBreaks(3).Location = Range("A518") Set ActiveSheet.HPageBreaks(4).Location = Range("A691") Range("B882").Select Set ActiveSheet.HPageBreaks(5).Location = Range("A859") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Page Breaks | Excel Discussion (Misc queries) | |||
setting page breaks for whole spreadsheet to be consistent? | Setting up and Configuration of Excel | |||
setting page breaks. | Excel Programming | |||
Setting page breaks (another) | Excel Programming | |||
Are conditional formats available for setting page breaks? | Excel Discussion (Misc queries) |