Apply filters to specific range; includes optional
worksheet parameter.
Author: michael@excelexperts.co.uk
Sub Filters_Apply(Rng As String, Optional ws As String)
If ws <> "" Then
With Worksheets(ws)
.AutoFilterMode = False
.Range(Rng).AutoFilter
End With
Else
With ActiveSheet
.AutoFilterMode = False
.Range(Rng).AutoFilter
End With
End If
End Sub