I am creating a excel Add-in using visual studio 2010. I was able to get the cell address using this code.
label1.Label = Globals.MyAddIn.Application.ActiveCell.Address.ToString();
I want to get the cell value. Also if you can tell me how to set a value for a given cell.
Please help.
to get a cell value for the active cell the following should do it
or for a specific cell
To Set the value it is basically the reverse
EDIT
Try this. I know that this works as I have something like it working in my own addin.