Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all,
I've recorded the following macro and as it's recording the pagebreak is deleted without a problem. Private Sub CommandButton1_Click() Range("F143").Select ActiveSheet.HPageBreaks(1).Delete End Sub If I try to run the macro (making sure all the conditions are the same. ie the page break is there), I get the error message "Application - Defined or Object - Defined Error. Anyone know why this would happen. (I'm using Office 2000.) Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Recording a macro ... | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) |