How to add a criteria for blank cells for the auto filter

[Range("A1").AutoFilter Field:=23, Criteria1:="Overdue", Operator:=xlOr, Criteria2:="In Progress"]

The code above perfroms my autofilter which works, by filtering for the cells that have the words "overdue" or "in progress" in their cells for column W. how do i add a new criteria for the cells which are also black and make it an xor with the other two criterias?

Thanks.

From memory I do not think you could use the "OR" more than once, instead, you could use array, like

Please Login or Register  to view this content.