Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro doesn't work but recording it does.
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 |
#2
|
|||
|
|||
I don't know why it won't work.
Which line gets the error message in debug "Rob" wrote: 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 |
#3
|
|||
|
|||
Hi bj,
I missed your reply earlier but came across it just now. I don't have the problem now. It corrected itself somehow. Must have been a hiccup??? Rob "bj" wrote in message ... I don't know why it won't work. Which line gets the error message in debug "Rob" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |