Hi,
When I delete a table column with Cells.DeleteColumn, structured references to that column
in other formulas get silently re-pointed to the neighbouring column instead of becoming
#REF! the way Excel does. The for…...PutValue("Email"); ws.Cells["C1"].PutValue("Phone");..."=XLOOKUP(\"Bob\",myTable[Name],myTable[Email])"; Console.WriteLine(f.Cells["A1"]...