Creating a filter macro and an OR filter macro

[mille238]

Hi all,

I'm trying to create a filter macro that will select a specific column from a given worksheet and filter on a given variable.

I'm also trying to do the same thing with an OR operator. Ex: I need to filter: equals THIS OR equals THAT.

I want to try and keep them general so that I can reuse this macro. I want to be able to pass in what worksheet to perform the macro on, what column and what to filter on.

Any help would be greatly appreciated.

Thanks

 

[Trevor G]

Welcome to the Forum,

Take a look at this and see if you can adapt it. If not then please give specific information like column number and criteria.

Sub mcrFilter()
'
' mcrFilter Macro
'
'
Range("A1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$D$8").AutoFilter Field:=4, Criteria1:="=29", _
Operator:=xlOr, Criteria2:="=35"
End Sub