Need help to add criteria to autofilter

[marwagamal]

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

 

 

[faheemsd]

Dear @marwagamal 

Please specify the range for example"D1:D1000".

Get the total number of rows from the excel and provide range as D1:DTotalnumberofrows.

Regards,

Faheem

[marwagamal]

Thanks for your reply but is there any this should be entered regarding operator?

[marwagamal]

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 Object
Worksheet = GetWorkbook (handle, Nothing). ActiveSheet
Worksheet.UsedRange.AutoFilter (Field:= FieldToBeFiltered,Criterial := criteriaToFilter) but it throw this error Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC

please help