Post value to a specified cell in current row

Mar 20, 2014 at 8:42 AM
Hi guys,

Sorry in advance for such a basic problem.

I am developing a C# Add in that is a custom task pane.

Just wondering if there is any way to get the currently selected row of the work book and then post a value to a predefined column of that row. For instance, working row is 5 and the predefined column is B, so the value will be posted to 5B.

Cheers
Coordinator
Mar 20, 2014 at 8:51 AM
Hi,

Use the COM Automation interface (call ExcelDnaUtil.Application to get the root object). Then get the selected cell from Application.Selection or Application.ActiveCell or something. The Excel Object model is documented here: http://msdn.microsoft.com/en-us/library/office/ff194565(v=office.15).aspx.

-Govert