Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Apply same filter to all sheets in a workbook
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="manfareed, post: 6334734"] hi, this is my final code but i get an error...run time error 91 ?? Sub Filter_All_Booth() Dim WS As Object If WS.Name <> "Summary" Then For Each WS In Worksheets WS.Range("A2:p50").AutoFilter Field:=2, Criteria1:="Booth" Next WS End If End Sub thx [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Apply same filter to all sheets in a workbook
Top
