I am trying to select a row turn on auto-filter and then do an ascending sort for one column of data. I have recorded a macro from Excel:
' Macro1 Macro
ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.Add Key:=Range _
("A1"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
I have figured out how to turn on the filter. I'm having problems now activating the sort by ascending order.
If anyone has any insight into this that would be great. Thank you.