title: Selecting UsedRange in Columns and Rows in Sheet
body: <ul>
  <li>I have two sheets in my excel file, <code>DTMGIS</code> and <code>DTMEdit</code> </li>
  <li>the <code>DTMEdit</code> sheet is empty</li>
  <li>and I am trying to xopy  everything from <code>DTMGIS</code> and Paste only Values to Sheet  <code>DTMEdit</code></li>
  </ul>
  
  <p>I do not know how to select the <code>UsedRange</code> only and paste this to <code>DMTEdfit</code></p>
  
  <pre><code>Dim ws As Worksheet
  Dim LastRow As Long, LastCoulmn As Long, Header As Long
  Header = 2
  Set ws = ThisWorkbook.Sheets("DTMGIS")
  LastRow = ws.UsedRange.Rows.Count
  LastCoulmn = ws.UsedRange.Column.Count
  
  With ws.UsedRange
      .Select
      .Copy
  End With
  </code></pre>