title: Clear contents of a WorkSheet using macro, without clearing the clipboard
body: <p>How do I clear the contents of a excel sheet using macro, without clearing the contents of the clipboard?  </p>
  
  <p>I am currently using the below code(which is called by clicking a button on the sheet), but this clears the data in the clipboard, which I have copied from other source, and want to paste in the cleared sheet</p>
  
  <pre><code>Sub clearly()  
      Dim ws As Worksheet  
      For Each ws In ThisWorkbook.Worksheets  
          ws.UsedRange.ClearContents  
      Next ws  
  End Sub
  </code></pre>