title: vsto excel 2010 add in - get value of cell when contents refer to another cell and formula
body: <p>I'm trying to get the value of a cell using this:
      Globals.Sheet3.Cells.Range["A2"].Value2 as string;
  Cell A2 refers to a cell on a different sheet that in turn refers to a formula on another sheet. The code above always returns null. How can I get the text of cell a2? </p>