title: Given the name of an excel cell, how can i find its value?
body: <p>So in excel, you can assign cells names to avoid using Row and Column numbers. In this case, this is especially useful because I'm dealing with several excel sheets and do not know where this particular cell will be.</p>
  
  <p>How can I get the value of this cell? I'm currently looping through the entire worksheet looking for it, but I stumbled across this online, which would speed up my application considerably.</p>
  
  <p>If found posts online that suggest either <code>xlWorkSheet.Cells("CellName").Value</code> or <code>xlWorkSheet.GetCell("CellName").Value</code>. Unfortunately the cells method does not accept a string as an argument and the GetCell method does not exist. I'm using the interop library. Thank you in advance.</p>