Excel vba button to clear numeric content

  • Thread starter Thread starter phyky
  • Start date Start date
  • Tags Tags
    Excel Numeric
AI Thread Summary
To clear numeric content in specific ranges using a button, users can utilize a macro in Excel. Recording a macro provides the necessary code, which can then be modified to include or extend multiple ranges as needed. This approach allows for efficient automation of the task without affecting other content in the specified areas.
phyky
Messages
57
Reaction score
0
I want to clear numeric content(without clear others) in certain range with a button. example: $E$10:$H$26 and $K$11:$Z$15. What macro code should I have? Appreciate your help
 
Physics news on Phys.org
You can record a macro - it will give you the right code. Changing the ranges there (or extending it to multiple ranges) is easy afterwards.
 

Similar threads

Replies
31
Views
4K
Replies
5
Views
3K
Replies
2
Views
9K
Replies
0
Views
2K
Replies
10
Views
2K
Replies
4
Views
1K
Replies
6
Views
55K
Replies
1
Views
2K
Replies
4
Views
7K
Back
Top