title: How to Clear all the worksheet contents except for the specified cell
body: <p>I have an worksheet where I have few data's, I have created a button which is used to clear the data. The current code which I have written will clear all the data starting from "E2" Cell to the end of the worksheet. 
  I have a data in "R2" cell which I don't want to clear. 
  Is there any way to achieve the above requirement (Delete from 'E2' till the rest of the worksheet but don't clear the contents of 'R2' cell).</p>
  
  <p>Below is by Code :</p>
  
  <pre><code>  Private Sub CommandButton25_Click()
    Range("E2:XFD1048576").ClearContents  ' but I don't want R2 cell to be Cleared
    End Sub()
  </code></pre>