Sign in to follow this  
Followers 0
linbin

_Excel_FilterSet

2 posts in this topic

I can only display selected values (20, 40 and 60)  with the following code:

 

 

Local $aShow[] = ["20", "40", "60"]
_Excel_FilterSet($oWorkbook, Default, Default, 2, $aShow, $xlFilterValues)

But how to filter the values which are not (20 , 40 and 60) ?

Share this post


Link to post
Share on other sites



That example is from the help file with many other examples.  I you wanted a list of values as in the above example you could just change the numbers: ["1", "2, "3"]

If you want everything less than 100 then you would use "<100".  What are you trying to find specifically?  Is there not an example of that in the help file?


Build your own poker game with AutoIt: pokerlogic.au3 | Learn To Program Using FREE Tools with AutoIt

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0