Macro to filter 5 columns at once

P

Pindacko

Joined
Apr 26, 2006
Messages
3
Reaction score
0
Could anyone help with this code? I can't get it to run.

Thanks


Sub tester()

Selection.AutoFilter Field:=12 = 11 = 10 = 9 = 8, Criteria1:="=#*", Operator:=xlOr, _
Criteria2:="=0"

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro filter multiple criterea 5
filter that yeilds no results 6
Filter, Delete and Error handling - need help 4
Apply macro to all worksheets 15
Custom filtering in excel 2003 with more than 2 multifilter option 2
Custom filter 26
Help with autofilter and filtering a specific column 1
Error Handle problem 4

Top