title: How to clear a named range without using any VBA/Macros
body: <p>I'm trying to figure out a way to insert a button or similar that when pressed, will clear all members of a named range.  </p>
  
  <p>Basically, how to replicate this:</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
      Range("Input_Cells").ClearContents
  
  End Sub
  </code></pre>
  
  <p>What I want is to have a button, or some similar type of clickable/toggleable action, that when depressed would clear the contents of the Named Range.  I could probably manage this with a listbox with something similar to below, but I'd rather have a prominent button.</p>
  
  <pre><code>=if(list_option = "clear", input_cells = "", )
  </code></pre>