Hi,
I’ve recorded a macro to run a filter (as below) it and it works fine. The only problem I have is that sometimes a column will be added, or possibly removed from the sheet - meaning the filter won’t always work. Is there a way to make sure the filter always does what it does on the same column, regardless of any changes to the column's location?
Sub late()
'
' late Macro
'
'
Range("J8:J11").Select
Selection.AutoFilter
ActiveSheet.Range("$B$8:$J$94").AutoFilter Field:=9, Criteria1:="=*late*", _
Operator:=xlAnd
End Sub
Bookmarks