I have some code to sort a column on the active worksheet. But the code currently specifies the worksheet name. How can I get it to reference the active worksheet instead, so I can use with any filename?
Thanks,ActiveWorkbook.Worksheets("consolidatedASINS-lighting").AutoFilter.Sort. _ SortFields.Add Key:=Range("O:O"), SortOn:=xlSortOnValues, Order:= _ xlDescending, DataOption:=xlSortNormal
Jon
Bookmarks