Apply an autofilter to Row 6 across multiple worksheets

[Sgligori]

Hi All,

I have a workbook with multiple sheets, and I need to apply a filter to Row 6 in each one of these sheets. Does anyone know of a code that I coud use to execute this?

The VBA code I used to use when I needed the very first column filtered was the following. I'm not sure if the one below can just be tweaked to select the 6th row instead of row 1.

Sub autofilter()
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ActiveSheet.UsedRange.Select
Selection.autofilter
Next ws
Application.ScreenUpdating = True

End Sub

[Sgligori]

I figured it out- hope this helps any viewers of this thread out there!

Sub autofilter()
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ActiveSheet.Range("A6").Select
Selection.autofilter
Next ws
Application.ScreenUpdating = True

End Sub