title: Dynamic Array for Sort and Clear contents
body: <p>I have made an array for M2:Tx - The x will vary dependent code prior to this. </p>
  
  <p>What I would like to do is have a 'clear contents' function and 'sort' function for this array (m2:tx).</p>
  
  <p>I am just struggling to make the array DYNAMIC. If anyone could help. </p>
  
  <p>I believe it will be something along these lines: </p>
  
  <pre><code>k = sh.Range("A3").End(xlDown).Row 'This will give me the length. 
  
  Dim TaskDates As Range
  Dim StartCell  As Range 'First part of Array
  Dim EndCell As Range 'End of Array
  Set EndCell = Range("T" &amp; 2 + k) 'maybe 2 or 3
  Set StartCell = Range("M2")
  Set TaskDates = Range(StartCell, EndCell) 'Dynamic Range 
  </code></pre>
  
  <p>This will work i beleive, but is there a more succinct methodology.</p>