title: Excel VBA - select a dynamic cell range
body: <p>I want to be able to dynamically select a range of cells (the heading row), where the row is 1 but the columns with be for 1 to last column, where "A" is the first Column and where "M" is the last column. I know how to find the last column, but I don't know how to modified the below range to input the first and last column as "A" and "M".</p>
  
  <pre><code> Range("A1:M1").Select
  </code></pre>