ahuang3433
New Member
- Joined
- Jan 24, 2017
- Messages
- 39
VBA Code:
ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=38, Criteria1:= _
"Reference PjM Comment for PN"
ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=6, Criteria1:= _
"<>TBD*", Operator:=xlAnd
Hi,
Based on the filter criteria that I have here, I'm trying to create a variable where if there is data return based on the filter criteria to delete visible cell data on Column AL excluding the header row. If there is no data return, skip.