| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recorded Macro to Set page breaks generates error.
I recorded a Macro to generate page breaks. The code is:
ActiveSheet.ResetAllPageBreaks Set ActiveSheet.HPageBreaks(1).Location = Range("A68") When I try to run this macro, I get Runtime Error '1004', Application or Object defined error. Does anybody know of a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2003 macro generates compiler error on 2007 | Excel Worksheet Functions | |||
| blank row macro with page breaks | Excel Programming | |||
| blank row macro with page breaks | Excel Programming | |||
| blank row macro with page breaks | Excel Programming | |||
| Macro to insert page breaks when values in 1 or more columns changes | Excel Programming | |||
Threaded Mode
