topic Re: Need help to add criteria to autofilter in Product Forum

Need help to add criteria to autofilter

marwagamal — Sat, 20 Apr 2024 18:38:58 GMT

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

Re: Need help to add criteria to autofilter

faheemsd — Sun, 21 Apr 2024 11:27:39 GMT

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

Re: Need help to add criteria to autofilter

marwagamal — Sun, 21 Apr 2024 13:19:58 GMT

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

Re: Need help to add criteria to autofilter

marwagamal — Sun, 21 Apr 2024 22:47:11 GMT

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