• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Call advanced filter macro's in one macro

Dear all,
I want to create on macro which runs the folling two macro's:
1. first filter macro:
Sub FILTER_VISIE()
Sheets("Visie uitlijnen").Range("B3:r16").AdvancedFilter Action:= _
xlFilterCopy, CriteriaRange:=Range("B1:R2"), CopyToRange:=Range("C4:R4"), _
Unique:=False

End Sub
2. second filter macro:
Sheets("Strategie cascaderen").Range("B3:r16").AdvancedFilter Action:= _
xlFilterCopy, CriteriaRange:=Range("B1:R2"), CopyToRange:=Range("B4:R4"), _
Unique:=False

I've tried to run both macro's like this:
Sub RUNFILTERMACROs()
Call FILTER_VISIE
Call FILTER_STRATEGIE

End Sub
But this doesn´t work. Anybody suggestions on how I can make this work? I posted a printscreen and the file for some more clarification
Dear regards,
Marc
 

Attachments

  • ExcelQuestion.zip
    177 KB · Views: 5
Back
Top