private void ActivateAndCenterOn(AST.Address cell, Excel.Application app) { // go to worksheet RibbonHelper.GetWorksheetByName(cell.A1Worksheet(), _workbook.Worksheets).Activate(); // COM object var comobj = cell.GetCOMObject(app); // center screen on cell var visible_columns = app.ActiveWindow.VisibleRange.Columns.Count; var visible_rows = app.ActiveWindow.VisibleRange.Rows.Count; app.Goto(comobj, true); app.ActiveWindow.SmallScroll(Type.Missing, visible_rows / 2, Type.Missing, visible_columns / 2); // select highlighted cell // center on highlighted cell comobj.Select(); }