title: MS Excel VBA Macro Dynamic Range
body: <p>Here Is a sample of the table (with creepy sample data)</p>
  
  <pre>|Col A       |Col B     |Col C   |Col D     |Col E
  +------------+----------+--------+----------+-----
  |Number      |Value     |X       |Date      |Decimal
  |1           |        AA|X       |2012/01/01|.1
  |2           |        BB|X       |2012/02/01|.2
  |3           |        CC|X       |2012/03/01|.3
  |4           |        DD|X       |2012/04/01|.4
  |5           |        EE|X       |2012/05/01|.5</pre>
  
  <p>What needs to be done:</p>
  
  <ul>
  <li>Sort the table according to the "Value"(Col B in this instance) in a macro</li>
  </ul>
  
  <p>Conditions:</p>
  
  <ul>
  <li>The header values DOES NOT change</li>
  <li>I have to search the headers which will contain the word "Value" since it changes from Col C to Col D or Col A... B... E... </li>
  <li>Column headers ALWAYS stay at 1st row</li>
  </ul>
  
  <p>What I have done so far:</p>
  
  <ul>
  <li>Brute force the value...(BAD!)</li>
  <li>Search the header to find what column contains the header "Value"</li>
  <li>Get the column letter/number and store in a variable</li>
  </ul>
  
  <p>Problems:</p>
  
  <ul>
  <li>Using the column letter or number as basis for sort.
  (i.e. Range (colLetter &amp; ":" &amp; colLetter))</li>
  </ul>
  
  <p>Any help would be appriciated</p>