VBA to clear a filter

[Guitarmageddon]

Hello all....should be a simple one. Im working with some VBA i made forever ago and seem to have forgotten some of the stuff Ive learned.

Several steps in, I have a command to filter one of my columns, shown here. Filtering a filter dropdown (row 1 of sheet has filters) to show only the rows with "STOW" value

With ActiveWorkbook.Worksheets("Page1").AutoFilter.Sort
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
        ActiveSheet.Range("$A$2:$AY$" & Range("A" & Rows.Count).End(xlUp).Row).AutoFilter Field:=5, Criteria1:="STOW" _
        , Operator:=xlAnd
    End With

I do a few sorts on other columns in the meantime. When I go with what I thought was the command to clear the filter from that "STOW" column, it doesnt work.... I want to keep my filter dropdowns on row 1, but just show all the values again. Help?

This is the one I used elsewhere in the code, and it worked. Maybe Im missing some of the other context.

ActiveWorkbook.Worksheets("Page1").AutoFilter.Sort.SortFields.Clear

 

[GWteB]

How about:

Worksheets("Page1").ShowAllData

 

[Guitarmageddon]

How about:

Worksheets("Page1").ShowAllData

Yep did the trick. thanks! i should have known but now I can park that in memory haha

 

[Alex Blakenburg]

Just an FYI that will crash if there is no filter applied or autofilter is not turned on. Safer would be

    If Worksheets("Page1").FilterMode = True Then
        Worksheets("Page1").ShowAllData
    End If

 

[GWteB]

Just an FYI that will crash if there is no filter applied or autofilter is not turned on.

... and I really could/should have mentioned that ...
Ta!