VBA
Saturday, April 20, 2019
To unfilter data
To unfilter data
Sub unfilter()
Dim ws As Worksheet
On Error Resume Next
For Each ws In ActiveWorkbook.Worksheets
Sheets("Input Sheet").Range("A12:aq12").AutoFilter = False
Next ws
On Error GoTo 0
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment