title: Select Cell within a range that has a maximum value
body: <p>I am trying to select a cell in Excel VBA 2007</p>
  
  <p>Example in row 2, cells A through H have some numbers but cell B2 has the highest value. is there a formula that I could use to get the address of  the cell B2 ?</p>
  
  <p>Based on this, is there a way I could use a variable to select a Range(":") ?</p>
  
  <p>I am a newbie to VBA so any help would be much appreciated.</p>
  
  <p>Thanks </p>