richard smith

richard smith

  • NA
  • 327
  • 102.8k

C# to find text & sort that column descending

Jan 28 2013 10:23 PM
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)

Answers (2)