Filter Out Multiple Criteria in VBA

[jaszz]

Hi, I am trying to learn how to filter using VBA.

So I have column J with items that always varies except for two: "In Progress" and cells that are blank. What I am trying to do is remove everything else except "In Progress" and cells that are blank.

I am a newbie and I can't find anything on the internet that helps. Please any ideas?

 

[mole999]

for the learning, just record your actions, apply filter, select column, deselect all then select what you want, then stop recording