title: VBA Deleting buttons with a range
body: <p>I'm trying to figure out how to delete all buttons within a range. I've seen plenty of examples on how to delete all buttons within a sheet but not a range. I created a range variable the contains every possible occurance of a button (this is used to reinitialize a form of variable size). The problem is that range doesnt support the object .Shapes or .Buttons. </p>
  
  <pre><code>        Set totalTable = Range(ActiveCell, ActiveCell.Cells(1000, 1000))
          For Each gen_btn In totalTable.Shapes
             gen_btn.Delete
          Next
  </code></pre>
  
  <p>Any help would be appreciated. Also, I can't use ActiveSheet becuase there are buttons which i want to keep and becuase the macro is called by a button. Hence the need for a range. Thank you. </p>