title: VBA to select all columns in a worksheet and auto adjust all columns width in Excel 2010
body: <p>I have a worksheet with with over 1000 columns. How can I select all columns in that sheet and auto adjust every column width. I tried</p>
  
  <pre><code>Sheets(1).Select
  Selection.EntireColumn.AutoFit
  </code></pre>
  
  <p>But it didn't work. Any ideas?</p>