title: Why does Columns("F:F").Select select the entire sheet?
body: <p>I'm using a macro to do a lot of formatting on a reoccurring document in our organization. When I run the macro, the formatting is completed but the contents are deleted... This macro code was written using Record option.</p>
  
  <p>Using step through I determined the issue is coming from these commands:</p>
  
  <pre><code>Columns("F:F").Select 
  Selection.Delete Shift:=xlToLeft
  </code></pre>
  
  <p>DETERMINED ISSUE:
  While stepping through I notice the command:</p>
  
  <pre><code>  Columns("F:F").Select 
  </code></pre>
  
  <p>selects all the cells in the sheet. The next command deletes the sheets contents. Any idea what might cause this?</p>