So you've got it working now or not?
By the way, the sorting can be done like so...
Code:With Worksheets("Sheet5").ListObjects("Orig").Sort .SortFields.Clear .SortFields.Add Key:=Range("Orig[Account]"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal .SortFields.Add Key:=Range("Orig[Stock]"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With




Reply With Quote

Bookmarks