title: Delete cells without shifting them up
body: <p>I have vba macro to delete a selection of cells. Its shifting the cells up automatically after deleting them. I don't want the cells to be shifted up, as I have a chart below the cells and everything gets disturbed if they are shifted.</p>
  
  <p>Here is the code I am using to delete cells</p>
  
  <pre><code>ActiveSheet.UsedRange.Select
  ActiveSheet.Range("C2:H8").Select
  Selection.Delete
  </code></pre>
  
  <p>Let me know how can I delete them without shifting up.</p>