Forum Discussion

Iron Contributor

Oct 03, 2023

Solved

EXCEL clear Button

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 ...

admin

excel

Formulas and Functions

Macros and VBA

office 365

Office Scripts

OliverScheurich
Oct 03, 2023
gmj12345
Sub clear_range() Range("B7:B30").Clear End Sub
You can assign this macro to a button in cell B35.

OliverScheurich

Gold Contributor

Oct 03, 2023

gmj12345

Sub clear_range()

Range("B7:B30").Clear

End Sub

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

gmj12345

Iron Contributor

Oct 03, 2023

how to Macro heehe