phyky Messages 57 Reaction score 0 Thread starter Dec 19, 2014 #1 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
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
mfb Mentor Insights Author Messages 37,492 Reaction score 14,382 Dec 19, 2014 #2 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.
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.