How to focus or select a cell in Excel

c# vsto excel-2007
venkat picture venkat · Mar 25, 2010 · Viewed 23.5k times · Source

How to focus a cell in Excel VSTO using C# or to select first cell using C# in VSTO?

Answer

Mikael Svenson picture Mikael Svenson · Mar 25, 2010

Here is one way:

Excel.Worksheet activeSheet = ThisAddIn.ExcelApplication.ActiveSheet;
var range = activeSheet.get_Range("A1", "A1");
range.Select();

ThisAddIn is the name of my test project.

Related questions

How to easily create an Excel UDF with VSTO Add-in project

What I am trying to do is to create User Defined Functions (UDFs) for Excel using VSTO’s C# “Excel 2007 Add-in”-project type (since I just want to generate some general UDFs). As I am only trying to learn the …

Read More
How to open an Excel file in C#?

I am trying to convert some VBA code to C#. I am new to C#. Currently I am trying to open an Excel file from a folder and if it does not exist then create it. I am trying something …

Read More
How to reference Microsoft.Office.Interop.Excel dll?

I had developed a system that deals with excel sheets in 2006 using MS VS 2005. Now, I can not use the same reference with MS VS 2012. var app = new Microsoft.Office.Interop.Excel.Application(); Workbooks wbs = app.Workbooks;

Read More