Replacing visible cell value in excel sheet

[marwagamal]

i want to replace cells value from yes to no after applying filter to excel sheet to be more clear i have excel sheet that contains 5 columns i want to apply filter to column number 2 then replacing the visible cell values of column number 5 from yes to no can anyone help me

[Athiban_Mahamathi]

Hello,

you can try "Replace in Worksheet" action from MS excel VBO.

[marwagamal]

The problem will be in how to determine the search range as i want to replace the values of visible cell after applying filter only not the cell values of the whole worksheet 

[Athiban_Mahamathi · Accepted solution]

You can try giving the range as A:Z , I guess by default only the visible cells will be replaced. 

[marwagamal]

Thanks it works fine and yes the default replace only the visible cells

I just want another help i don't know how to add the criteria to autofilter as it didn't give me any result