SOLVED

EXCEL clear Button

Iron Contributor

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

gmj12345_0-1696335324126.png

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 

gmj12345_1-1696335529328.png

Error :(

 

2 Replies
best response confirmed by gmj12345 (Iron Contributor)
Solution

@gmj12345 

Sub clear_range()

Range("B7:B30").Clear

End Sub

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

 

how to Macro heehe
1 best response

Accepted Solutions
best response confirmed by gmj12345 (Iron Contributor)
Solution

@gmj12345 

Sub clear_range()

Range("B7:B30").Clear

End Sub

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

 

View solution in original post