Simple Filter (and Cancel Filter)

[rob1987]

Hello,

I think this should be a really easy code but I'm really not sure how to do it.

Basically, I want to set up a Macro in an worksheet called "input" that filters all rows based on the cell value in column C being greater than or equal to 0.

I'm going to set up a command button to do this rather than having to go through the process of filtering each time.

This leads me onto the second part, is there a seperate code to remove the filter?

Many Thanks,

 

[JackDanIce]

Code for first part:

Sub MyFilter ()
With Sheets("Input")
    .Select
    .Range("C1").CurrentRegion.AutoFilter Field:=3, Criteria1:=">=0", Operator:=xlAnd
End With
End Sub

Code for second part:

Sub RemoveFilter ()
With Sheets("Input")
    If .AutoFilterMode Then .AutofilterMode = False
End With
End Sub

 

[rob1987]

Thanks Jack.

I worked out I could also just Record Macro, set the filter, and stop recording. And then the same for clearing it.