VBA autofilter error

[VBABEGINER]

Below, my filter is not applied...it giving me an error..

Run time error 1004
AutoFilter method of Range class failed

Pls suggest..

    Range("A5").Select
    ActiveWindow.FreezePanes = False
    
    Range("A4").Select
    Selection.AutoFilter
    
    Range("AF4").Select
    ActiveSheet.Range(Cells(4, 32), Cells(LstRw5, 32)).AutoFilter Field:=32, Criteria1:=nm

 

[shg]

Re: Need help on filter

Range("AF4", Cells(Rows.Count, "AF")).AutoFilter Field:=[U]1[/U], Criteria1:=nm

Field is referenced to the first column of the autofilter range.

 

[VBABEGINER]

Re: Need help on filter

Thank You so much, SHG..

 

[VBABEGINER]

Re: Need help on filter

Range("AF4", Cells(Rows.Count, "AF")).AutoFilter Field:=[U]1[/U], Criteria1:=nm

Field is referenced to the first column of the autofilter range.

Hey Hi, SHG...Sorry for pop-upd again...
but the filter is not working on Col AF i.e. 32 number Column..
I want to filter on AF values..

Pls suggest..

 

[shg]

It works in Texas, exactly as written. What column is it filtering for you?

 

[VBABEGINER]

Col A..

 

[VBABEGINER]

Dear All,

I got the solution, just sharing with you all..

Worksheets("worksheetName").Range("AF4").AutoFilter field:=32, Criteria1:=nm