AutoFilter a table with an array as criteria

[brucemc777]

This will get worse in the next step, but as I can't even master the basic when I reduced my problem to basics I will start here...

Please Login or Register  to view this content.

Is definitely not working for me. Each array element resolved fine in the Immediate window, so the array is proven good.

I am here because I went out, did searches, read what was written and by several examples the above is supposed to work unless I copied something wrong. When all else fails I go as basic as I can and build up. When I gave Criteria1 a given single value, say "Present" it worked fine.

I also tried:

Worksheets("Directory").ListObjects("tblDirectory").Range.AutoFilter field:=2, Criteria1:=Array("Present", "Absent"), Operator:=xlFilterValues

and as always got my error 1004.

I now suspect I am missing something obvious as I am getting a bit frustrated. Can someone point out what I am missing so I can make the basic work and then go on to the next issue?

Many Thanks!!!

[brucemc777]

Well, so far I know something is not right in my project as I am experimenting with a new workbook with nothing else in it and am able to get things done such as the filter on the two named element array that I could not in the major project, so please hold off until I am able to further isolate my problem-

edit- My problem is nothing short of my computer being possessed and in need of an exorcism.
Absolutely no idea what is going on. Tried the experimental code from the bare workbook in the main project and it worked. Un-commented out the lines of the code that was not working and they worked. I am a worthless target if someone simply wanted to mess with me, and I employ a number of anti-malware layers, so it's got to be demonic possession.

I apologize for taking your time-

Now I can post the real brain-teaser...