title: Copying Column D to Column A Excel VBA
body: <p>So the problem is that I wanna copy a filtered sheet, this means that Columns A,B,C are gone so it starts at D. When copying using this bit op code it will copy it to Column D again but I need it to reorganize itself and copy to Column A in a new sheet.</p>
  <p>Thanks in advance!</p>
  <pre><code>Option Explicit
  Sub Copy()
  Dim rng As Range
  Sheets.Add.Name = &quot;TEST2&quot;
  Set rng = &quot;Worksheets(&quot;TESTSHEET&quot;.Range(&quot;A1:ZZ1000&quot;)
  Worksheets(&quot;TEST2&quot;).Range(&quot;A1&quot;).Resize(rng.Rows.Count, rng.Columns.Count).Cells.Value = rng.Cells.Value
  End Sub
  </code></pre>