Hai guys
I have to sort data with custom sort (I mean with my own sorting order) but it is not working can you plz help to solve guys
Range ("L1").Select
Selection.Autofilter
Activeworkbook.Worksheets("KK").Autofilter.Sort.Sortfields.Clear
Activeworkbook.Worksheets("KK").Autofilter.Sort.Sortfields.Add2 key:=Range("L2:L49"),Sortonvalues,order:=xlAscending,Customorder:="HL,VL,ML,SL,BL",Dataoption:=xlsortnormal