access specific cell from excel add-in vsto

How can I access as specific cell B1 from my excel add-in vsto in microsoft visual studio 2010.

Globals.Sheet1.Range(“B3”).Value this does not work as it seems its the syntax for excel document instead of excel add-in.

---

edit this seems to work

    Microsoft.Office.Interop.Excel.Worksheet activeSheet = Globals开发者_运维知识库.ThisAddIn.Application.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet;
    var currentCells = activeSheet.get_Range("A1", "E1");
    currentCells.Select();

but then how do I select specific values in currentCells?

---

Try something along these lines:

var excel = Globals.ThisAddIn.Application;
var activeSheet = (Worksheet)excel.ActiveSheet;
var cell = activeSheet.Range["B1", Type.Missing];
var content = cell.Value2;

---

You could do Range.Find(...), and then FindNext, adding found cells to list

Alternatively, you could iterate over all Range.Item[i,j] for i = 1 to Range.Rows.Count (==1 in your case) and j=1 to Range.Columns.Count like this and check the values of individual cells as you go.

Use Application.Union to combine multiple Ranges from the acquired list and do Select() on the combined range