Macro to autofilter same filter across selected worksheets (not all worksheets)

[wizardharry]

Just need a code to autofilter across selected worksheets.
Already have the autofilter code just require the code to repeat the autofilter across a selected array of worksheets.

Please Help!!

 

[JLGWhiz]

This uses an array of the selected sheets, then calls the sheets one at a time to do the filtering and other work

Sub selectedsheets()
Dim shAry As Variant
shAry = Array("Sheet2", "Sheet5", "Sheet6", "Sheet8")
For i = LBound(shAry) To UBound(shAry)
	With Sheets(shAry(i))
		.Range("A2:Z100").AutoFilter 1, "X")
		'etc. code to do something
		.Range("A2:Z100").AutoFilter 'Turn filter off
	End With
Next

 

[wizardharry]

Unfortunately, it still only filters the current worksheet i have open. Any reasons why this could be
?

 

[JLGWhiz]

Unfortunately, it still only filters the current worksheet i have open. Any reasons why this could be
?

Please post the code you used so we can see it.