In my code I'm filtering on column "X". In the code below column 'X' is represented by COL_CONCAT. If I open the workbook and run the code it works as expected but if I try it again it doesn't and I have to close and reopen the workbook. How can I correct that?
Code:' Clear any previous autofiltering On Error Resume Next .ShowAllData On Error GoTo 0 .Range(.Cells(1, COL_CONCAT), .Cells(lngLastRow1, COL_CONCAT)).AutoFilter Field:=1, Criteria1:="blah"