Auto Filter using Last Row

[Guzzlr]

Hello.
I am trying something new, and of course it is not working.
I have:

ActiveSheet.Range("$A$5:$Z$ & Last Row").AutoFilter Field:=2, Criteria1:= _
"3A - High Sustain"

I'm trying to filter down to my last row (last row is working correctly)
What am I doing wrong?
Thanks

 

[Fluff]

Try, you have the final quote in the wrong place.

ActiveSheet.Range("$A$5:$Z$" & Last Row).AutoFilter Field:=2, Criteria1:= _
"3A - High Sustain"

 

[Guzzlr]

ohh...Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.