Filter function with evaluate

[YasserKhalil]

Hello everyone

I have names in the range A1:A10 and A1 has the name "Yasser" and A7 has the name "Ahmed" and other cells with other names
I have tried this line so as to filter and get the rows that has the value "Ahmed" or "Yasser"

Please Login or Register  to view this content.

But when following the code I found x has all the rows and I expect to get 1 and 7 row only
Any help at this point.

[jindon]

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot my tuotr. So is there a difference between ANd and using + ( I thought they are the same). And When I used AND instead of OR, I got an error.

[jindon]

I don't understand what you are talking about.

There is no "AND" function in your original formula string.

+ or "OR", * for "AND"

Both "AND" & "OR" function only works in special conditions in Evaluate method.

[YasserKhalil]

Thank you very much. Now I got it.
Best Regards

[YasserKhalil]

When I try to use it like that, I got an error

Please Login or Register  to view this content.

[jindon]

Number of opening bracket and closing bracket doesn't match.

[YasserKhalil]

I adjusted the number of brackets and now no error but x in the Type column of Locals window is >> Variant/String (0 to -1)

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[YasserKhalil]

This is as in post #6 and this throws an error. Can you post it in full to make sure?

[bakerman2]

Code in Post#8 works just fine. With 5 names in range gives me Variant/String(0 to 4).

Please Login or Register  to view this content.

[jindon]

Delete the red closing bracket.

[YasserKhalil]

Thanks a lot. It was my fault as I was activating another sheet during the test process.
Last question: how can I skip if the x is 0 to -1 (Would I use the Ubound(x) = -1?)
And how to refer to sheet1 in the line .. so as to avoid the error if I was in another sheet?

[jindon]

Correct.............

Sheets("Sheet1").Evaluate("........")

[YasserKhalil]

Thank you very much for all of you

Last question: how can I skip if the x is 0 to -1 (Would I use the Ubound(x) = -1?)
And how to refer to sheet1 in the line .. so as to avoid the error if I was in another sheet?

[bakerman2]

Please Login or Register  to view this content.

[jindon]

See my post #14

Worksheet Evaluate method is the fastest.

[YasserKhalil]

Thank you very much for this great information. All is great now
** As for using Evaluate doesn't throws error when concatenting the line. But using the brackets [] throws error
Isn't the use of [ __] is the same as Evaluate("__")?

Please Login or Register  to view this content.

[jindon]

You can't use variable with a short cut notation of Evaluate, i.e. [].

[YasserKhalil]

Thanks a lot for the information.
I have enjoyed a lot this topic...

Best Regards for All of You.

[YasserKhalil]

Is it possible to get the part of Row(1:10) as a variable depending on a range

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jindon]

row(" & r.address & ")

[YasserKhalil]

Thanks a lot and sorry for disturbing you again and again.. I am just try to learning more about this topic.

[YasserKhalil]

What if I decide to hide the rows stored in the x varaible
I tried this

Please Login or Register  to view this content.

But it doesn't work as the row number should be 1:1 and 7:7 or I have to loop through the x values and do it one by one ..

[jindon]

Don't do like that,

Subscript of Range limited to 256 characters, so if you are dealing with large data, it will destroy whole thing.

[YasserKhalil]

Thanks a lot. Is there a faster alternative?

[jindon]

Simply autofilter.

[YasserKhalil]

I don't mean using AuotFilter at all. I mean depending on the variable x which has rows numbers that I need to hide.
Or how can I filter multiple rows based on the variable x?

[jindon]

There maybe a several ways to accomplish one thing.
So, why are you making things too complex meaninglessly by choosing the wrong way?

Autofilter is absolutely faster.

[YasserKhalil]

As I told you, I am just playing around using Filter VBA Function with Evaluate .. to learn new stuff
Thanks a lot for the great information in this topic.

[jindon]

Please Login or Register  to view this content.

Do it for yourself for 256 limit.

[YasserKhalil]

Thanks a lot for the nice trick. This is what I am seeking to in this topic in fact.
I have no specific problem at all. I am just playing with such lines so as to discover the tips and tricks .. I have to thank you in each post for all these useful tricks.

[YasserKhalil]

If you find any free time. Not now because I exhausted you
How can I apply multiple filter based on the rows numbers stored in the x variable? Give me simple example to get it well.

[jindon]

Are you always forget what you got helped or you leave yourself not try to learn?

https://chandoo.org/forum/threads/gr...-method.28031/

[YasserKhalil]

This is from 2016 so certainly I forgot about it. Forgive me ..
And not all the issues I posted I can get all the information from it well. I am trying to learn as possible as I can. But it is natural to forget my tutor.

[jindon]

No excuse, everything is there.
Learn from what you got helped first and not ask same thing again and again.

[YasserKhalil]

OK my tutor.
Best Regards

[YasserKhalil]

I have tried to do that across a row not a column like that

Please Login or Register  to view this content.

I have played a round but every time I got an error.

[jindon]

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot. So we use Transpose when dealing with column range but we don't need it as already we are dealing with a row.
Regards