How can I get the selected cells in an Excel COM add-in?

[siftach]

I made a COM add-in for excel and I manage to get everything except for the collection of the selected cells. In VBA there is a collection called Selection and from what I understood the Excel.Application has a Selection collection as well, but I do not know how to access the members of this collection.

I am using VS 2005 and developing in .NET 2.0.

 

[djj55]

Several threads cover Excel. I would suggest looking at the MSDN article 306022 or 301982
djj

 

[siftach]

I did read those artivles, the problem is that the code there is not 100% correct. I actually managed to solve the problem by ignoring the warning MSDEV gave me with this code:

Dim oExcel As Excel.Application
Dim oCell As Excel.Range

For Each oCell In oExcel.Selection
AddPhone(oCell.Value.ToString)
Next