private void add_ListColumn(object sender, RibbonControlEventArgs e, string ColName)
{
Excel.Worksheet thisSheet = Globals.ThisAddIn.Application.ActiveSheet as Excel.Worksheet;
Excel.ListObject thisList = ExcelHelpers.GetListObject(thisSheet);
ExcelHelpers.AddListColumn(thisList, ColName, 0);
}
private void updateCalenderYear(Excel.ListObject LO, Excel.ListColumn LC, int rowStart)
{
Excel.Range LCDate = ExcelHelpers.GetListColumn(LO, "Date").Range;
if (LCDate == null)
{
LCDate = ExcelHelpers.AddListColumn(LO, "Date", 1).Range;
}
updateRowCYFormula(LO, LC, rowStart);
}