R
Raz
Sub Button1_Click()
Range("A110").Clear
Range("A1215").Clear
End Sub
I am using a button with this code above to reset those cells to blank
(deleting prevoius data). But it is deleting all the formatting also.
What do I need to change or add to the code above to clear the text and
numbers keeping all the formatting as it is.
Also should I use a Form control button or ActiveX control button ?
Range("A110").Clear
Range("A1215").Clear
End Sub
I am using a button with this code above to reset those cells to blank
(deleting prevoius data). But it is deleting all the formatting also.
What do I need to change or add to the code above to clear the text and
numbers keeping all the formatting as it is.
Also should I use a Form control button or ActiveX control button ?