C# to find text & sort that column descending
I have been running this in VBA, and need to know what the C# equivelant is:
With Intersect(ws.UsedRange, ws.Rows(1).Find("Called On", , , xlWhole).EntireColumn)
.EntireRow.Sort Key1:=.Cells, Order1:=xlDescending, HEADER:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
.NumberFormat = "mm/dd/yy"
End With
I am looking for the text "Called On" in Row 1, and sorting that column DESC then formatting that column in mm/dd/yy format. What would the C# equivelant of this be?
EDIT
This is C# working with data in an Excel Spreadsheet (.xlsx format)