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


    User Avatar
    2017 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

Similar Threads - Excel button clear Date
Putting Excel graph into LaTeX Feb 10, 2018
Excel Error Bars Nov 26, 2017
Plotting two matrices in Excel Jan 5, 2017
Excel Plots Labels Jan 5, 2017
Mathematica: Duplex Printing from button inside DialogNotebook on Mac Jun 19, 2013