Filter multiple columns in excel

[kamalteja]

Hi,
I want to filter multiple values of a particular column, i'm able to do only for one column
Ex:

Code:

Value1 = "Hello"
Value2 = "World"
ExcelSheets1.Range("J1").AutoFilter 10, V1, 2, V2

In the above line of code, I need to V1 and V2 during runtime which could be more, when i'm trying to concatenate V1,2,V2 and put as a string it is not working, the 2 should be considered as numeric value to act as "Or" operator but instead it is considered as string

The condition in the excel filter looks like "Hello,2,World" as one string and no records are fetched