title: c#,excel: getting range info
body: <p>i have a c# code which gets the (excel-2007) worksheets used range as follows</p>
  
  <pre><code> Excel.Worksheet ws = (Excel.Worksheet)Globals.ThisAddIn.GetActiveWorksheet();
   Excel.Range range = (Excel.Range)ws.UsedRange;
  </code></pre>
  
  <p>for the current worksheet i know exactly that range is A1:HM232,...but in the future that range may change... how is it possible to get the range info such as A1:HM232 from the used range info?</p>
  
  <p>i can get the rows.count and columns.count... but how to get info such as "HM"?</p>
  
  <p>the reason behind this is that i'm trying to put it later on a formula like</p>
  
  <pre><code>=Sheet1!A1:HM232...
  </code></pre>
  
  <p>thanks in advance!</p>