title: Deleting unwanted columns starting at a specific row - excel vba
body: <p>For some reason I can't figure out how to do this... it seems so basic: </p>
  
  <p>Trying to delete unwanted columns starting at a specific row.</p>
  
  <p>Example:
  Want to delete Columns C, D, E, M, N and L all starting at row 10 of Wsh2. </p>
  
  <pre><code>'deleting columns that are unwanted
  Cells(wsh2.Cells("C10"), wsh2.Cells("C10").End(xlDown)).EntireColumn.Delete
  Cells(wsh2.Cells("D10"), wsh2.Cells("C10").End(xlDown)).EntireColumn.Delete
  Cells(wsh2.Cells("E10"), wsh2.Cells("C10").End(xlDown)).EntireColumn.Delete
  Cells(wsh2.Cells("M10"), wsh2.Cells("C10").End(xlDown)).EntireColumn.Delete
  Cells(wsh2.Cells("N10"), wsh2.Cells("C10").End(xlDown)).EntireColumn.Delete
  Cells(wsh2.Cells("L10"), wsh2.Cells("C10").End(xlDown)).EntireColumn.Delete
  End Sub
  </code></pre>
  
  <p>I've adapted a previous code that I found on here that used Range. I've also attempted using Union and Range but cant seem to figure it out. </p>
  
  <p>Basically: Trying to delete only specific columns starting at a particular row after I've copied a range of rows from a previous worksheet. </p>
  
  <p>Any help would be great. Thank you!</p>