Multiple Criteria for Autofilter using And & Or

Hi I am getting a compilation error stating 'Application-defined or Object-defined error' on the following statement

Please Login or Register  to view this content.

Filter_Range is variable for the range and is set OK (there are multiple other filters applied before and after which work fine)
C_DUEDATE is a constant for the Column Number
ds is date start as a date serial, de is date end as date serial

My feeling is the error is something to do with mixing And and Or in same filter? is there any way of 'adding brackets' it should be value = N/A or (>=ds and <=de) but not sure exactly how to do this?

Alternatively is there a filter add. So I could filter out the date range and then add any that are N/A

Help as always much appreciated.

There are only 2 criteria allowed in an autofilter. Perhaps you could use an advanced filter instead? If you do need autofilter, you'll need an additional formula column that checks your three criteria and then filter on the new column.