EXCEL clear Button

[gmj12345]

Clear button or any possible way to clear multiple cell by just clicking or creating a define instruction

Is that possible in Excel?

Sample Image

So everytime I want to clear datas in B7 to B30 I will just press the clear or the B35 command possible?

Tried something like this 

Error :(

[#2 · Accepted solution]

@gmj12345 

Sub clear_range()

Range("B7:B30").Clear

End Sub

You can assign this macro to a button in cell B35.

[#3]

how to Macro heehe