Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel vba button to clear numeric content

  1. 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
     
  2. jcsd
  3. Dec 19, 2014 #2

    mfb

    User Avatar
    2016 Award

    Staff: Mentor

    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.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook