How do I find which cells are selected on an Excel worksheet?

Question

I need to be able to use C# and Excel interop to determine which cells are selected in a workbook/worksheet. It would be nice if there were something like this defined in Excel:

Excel.Range Worksheet.GetSelectedCells();

But I don't find that in any documentation. How can I do this?

tia.

Answer 1

I guess you can use the ActiveCell property of the Excel Application object. It would return you a Range object.

HTH Rauts

Answer 2

Use Application.Selection which will return a Range.