EXCEL VBA : Clear all cells with one click - vba code

Submitted by techrev on Tue, 08/15/2017 - 11:44
Forums

Private Sub CommandButton1_Click()
ThisWorkbook.Sheets("Sheet1").Range("A1:Z100").Clear
End Sub