I need help to add criteria to autofilter as I'm trying to filter on صيدليه from D column in the sheet in the screenshot but it didn't give me any result noting that i tried also operator 2 and turned on the autofilter Any help please
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...
Hi All,
I'm new to BP and i have issue when I'm trying to configure Email - POP3/SMTP/IMAP I got the error in the attachments, i also attached the configuration step to kindly check if there is something wrong.
thanks in advance.
----------------...
I tried to set the range with no result also it didn't throw any error also i don't know where is the problem also i tried many time this code Dim worksheet as ObjectWorksheet = GetWorkbook (handle, Nothing). ActiveSheetWorksheet.UsedRange.AutoFilter...
Thanks it works fine and yes the default replace only the visible cellsI just want another help i don't know how to add the criteria to autofilter as it didn't give me any result
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