Excel vba button to clear numeric content

  • Thread starter phyky
  • Start date
  • #1
57
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
 

Answers and Replies

  • #2
35,259
11,510
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.
 

Related Threads on Excel vba button to clear numeric content

  • Last Post
Replies
0
Views
2K
Replies
0
Views
2K
Replies
2
Views
7K
Replies
6
Views
54K
Replies
10
Views
8K
  • Last Post
Replies
18
Views
3K
  • Last Post
Replies
1
Views
921
Replies
3
Views
2K
Top