How to filter 'Contains" data by using VBA

[ThrottleWorks]

Hi,

I am trying to filter "Contains" data by VBA.

For example in Column A I want to filter data containing value ABC.
Can anyone help me in this please.

I forgot to mention, I am filtering a string with VBA that is why I am getting confused about how to add contains criteria to the string.

 

[Somendra Misra]

Hi Sachin,

Try using "=*abc*" in criteria.

Regards,

 

[ThrottleWorks]

Hi Somendra,

I am trying this and will share the results shorlty.

Thanks a lot for the help.

 

[ThrottleWorks]

Hi Somendra,

I tried this but tt is not working.

Thanks for the help.

Good night.

 

[Jagdev Singh]

Hi Throttle

Please upload a sample file for better understanding.

Regards,
JD

 

[ThrottleWorks]

Hi @Jagdev Singh , please see attached file.

Thanks for the help !

 

[Somendra Misra]

Hi Sachin,

See this file. Push The string not declared button.

Regards,

 

[ThrottleWorks]

Good morning Somendra,

Thanks for the help. I need to use the string.
I am required to filter values from a range, say from A1:A10 and perform actions.

That is why I can not use abc, it may be def or feg in next run.

PS - Please let me know if you need further details.

 

[Somendra Misra]

Hi Sachin,

I did not understand the code filter all the values that contains abc in them.

Regards,

 

[ThrottleWorks]

Sir, sorry for making it confusing.

I have Range G2:G3.
I need to find G2 and G in range A1:D9.

I have a loop, which will pick value from G2 and filter data containing "ABC" in range A1:D9.

Next line, loop will pick value of G3 which is DEF and filter data containing DEF in Range A1:D9.

For this I need to use string and filter data "contains".

 

[NARAYANK991]

Hi Sachin ,

Is it something like this ?

ActiveSheet.Range("$A$1:$A$7").AutoFilter Field:=1, Criteria1:="*" & Range("G2").Value & "*", _
    Operator:=xlOr, Criteria2:="*" & Range("G3").Value & "*"

Narayan

 

[ThrottleWorks]

Hi @NARAYANK991 Sir, Yes ! This is what I was trying to do.

It's working perfect, though I am not able to use MyString in the above mentioned line of yours, I will try to find a workaround this.

But this is what I was trying to do, filter the data "Contains".

Thanks a lot for the help.