title: Create an Excel Macros to Delete Rows based on the selected cells in a Sheet
body: <p>I have created a macro however its not really working since the rows actually change during the delete. The user select any # of cells in a table. On run of the macros, just those rows which belong to the selected cells are deleted. Here is what I got to so far:</p>
  
  <pre><code>Sub DeleteSelectedRows()
  Dim Cell As Range
  With Sheet1
  For Each Cell In Selection
          .Range(Cell.Address).EntireRow.Delete
  Next Cell
  End With
  End Sub
  </code></pre>
  
  <p>Any help would be greatly appreciated.</p>