private void autoyear_Click(object sender, RibbonControlEventArgs e) { Excel.Worksheet thisSheet = Globals.ThisAddIn.Application.ActiveSheet as Excel.Worksheet; Excel.ListObject thisList = ExcelHelpers.GetListObject(thisSheet); ExcelHelpers.AutoSetYear(thisList, 12); }