Macro doesn't work but recording it does.

[Rob]

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

 

[Guest]

I don't know why it won't work.
Which line gets the error message in debug

 

[Rob]

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