static void SetSelectedRanges(SpreadsheetControl control) { control.BeginUpdate(); Worksheet worksheet = control.ActiveWorksheet; CellRange r1 = worksheet.Range["A1:B10"]; CellRange r2 = worksheet.Range["E12"]; CellRange r3 = worksheet.Range["D4:E7"]; List <CellRange> rlist = new List <CellRange>() { r1, r2, r3 }; control.SetSelectedRanges(rlist); control.SelectedCell = worksheet.Cells["E5"]; control.EndUpdate(); }