Simple Filter

[Maria Clara]

Hello All, I'm utilizing the code below to filter a data in a Sheet.


It does select the cells I want to filter but the filtered cells are not visible to me.


Selection.AutoFilter Field:=2, Criteria1:="#N/D"


Can you pls help me to correct the code?


Thank you.

 

[sdsurzh]

Hi Maria,


Can you try applying filter by manually. If it works then there should be problem with Field or Criteria.


Thanks,

SK