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

    phyky

    User Avatar

    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
     
    phyky, Dec 19, 2014
  2. jcsd
    Phys.org - latest science and technology news stories on Phys.org
  3. Dec 19, 2014 #2

    mfb

    User Avatar
    Insights Author
    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.
     
    mfb, Dec 19, 2014
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Excel vba button to clear numeric content

  1. Excel VBAWriting a .txt file to an Array or Wrksht (Replies: 10)

  2. VBA with Access and Excel Help (Replies: 0)

  3. Excel VBA change (or edit ) links Macro (Replies: 2)

  4. Simple Excel VBA problem; Applying a formula to a column if it contains a number (Replies: 0)

  5. CST - Access CSTResultReader.dll from EXCEL VBA (Replies: 0)

Loading...