My current code is:However, I'm working with multiple sheets, and column 16 isn't always the column I want to filter, but it's always the last column I want to filter. How would I change my code to do that?![]()
ActiveSheet.UsedRange.AutoFilter Field:=16, _ Criteria1:="0", _ Operator:=xlOr, _ Criteria2:="(0)"
Thanks,
John
Bookmarks