Multiple Filters with "or"

[longjonsilvr]

I have 3 sets of filters I want to apply. I have no problem with the filter code, its the "Or" code between filters im struggling with.

Currently I have:

SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"

Then I need "OR"

SetAutoFilter FieldName:="Start", FilterType:=pjAutoFilterThisWeek
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="100%"

Another "OR"

SetAutoFilter FieldName:="Status", FilterType:=pjAutoFilterLate
SetAutoFilter FieldName:="% Complete", FilterType:=pjAutoFilterCustom, Test1:="does not equal", Criteria1:="On Schedule"



Does anyone have any ideas how to replicate is filter in code.

[JosephCraig]

I am looking for some function to simply the complicated validation task. If you get the solution please share here also.