07-08-2013, 02:28 AM
Hi,
I want to filter multiple values of a particular column, i'm able to do only for one column
Ex:
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
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, V2The condition in the excel filter looks like "Hello,2,World" as one string and no records are fetched