Please help me with the bellow code, can some please edit so cell b3:c3 and b4:c4 need to be cleared when the button pressed.
Private Sub ResetFormButton_Click()
ActiveSheet.Unprotect
On Error Resume Next
[b3, b4, B5, b6, b7, b8, b15, b16, b26, b27, B28, B29, B31, e12, e16, f3, f4, f5, f6, f7, g15, g16, g19, g22, g23, g24, h3, h4, h5, h6, h7, i15, i16, i19, i20, i22, i23, I24].ClearContents
On Error GoTo 0
ActiveSheet.Protect AllowFiltering:=True
Range("i2").Select
End Sub
Thank you all in advance
Private Sub ResetFormButton_Click()
ActiveSheet.Unprotect
On Error Resume Next
[b3, b4, B5, b6, b7, b8, b15, b16, b26, b27, B28, B29, B31, e12, e16, f3, f4, f5, f6, f7, g15, g16, g19, g22, g23, g24, h3, h4, h5, h6, h7, i15, i16, i19, i20, i22, i23, I24].ClearContents
On Error GoTo 0
ActiveSheet.Protect AllowFiltering:=True
Range("i2").Select
End Sub
Thank you all in advance