Hello Everyone
I have an Excel macro, which amongst other things applies an autofilter, finds references for a specific entry and deletes the rows with that entry in it. However I would like for that autofilter to be turned off after the deletion has taken place, but I cant seem to get it to work, or at the very least keep the autofilter on but have it looking for no specific data (so it is in effect off). Can anyone help to show what I am doing wrong.
Ta
Mav
The Code I am using is as follows.
Sheets("ImportData").Select
Columns("B:B").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="Mop, Mrs"
Range("A1").Select
ActiveCell.Offset(1, 0).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
Selection.AutoFilter
I have an Excel macro, which amongst other things applies an autofilter, finds references for a specific entry and deletes the rows with that entry in it. However I would like for that autofilter to be turned off after the deletion has taken place, but I cant seem to get it to work, or at the very least keep the autofilter on but have it looking for no specific data (so it is in effect off). Can anyone help to show what I am doing wrong.
Ta
Mav
The Code I am using is as follows.
Sheets("ImportData").Select
Columns("B:B").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="Mop, Mrs"
Range("A1").Select
ActiveCell.Offset(1, 0).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireRow.Delete
Selection.AutoFilter
