Forum Discussion
gmj12345
Oct 03, 2023Iron Contributor
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 B7 to B30 I will just press the clear or the B35 command possible?
Tried something like this
Error 😞
Sub clear_range() Range("B7:B30").Clear End Sub
You can assign this macro to a button in cell B35.
2 Replies
- OliverScheurichGold Contributor
Sub clear_range() Range("B7:B30").Clear End Sub
You can assign this macro to a button in cell B35.
- gmj12345Iron Contributorhow to Macro heehe