I simply want to use vba's autofilter to find all values in column G(7) in a cell containing several lines of wrapped text The value can be (1) the first word, (2) in the middle of the text, (3) or the last word. in the text
This is all I'm looking for. As you can see, the result brown, is in the middle of the text if the autofilter criteria works correctly. But as mentioned, correct code should also pull up brown if its the first or last word although I did not include this in the example below.
This is just a simple cell with a lot of text for memo descriptions. Should be easy if wildcard, etc., parameters (*=, etc.) are done correctly.
Note: I know FIND easily does this, but I much prefer Autofilter because it uses much less code and no For Each loop..
I really appreciate anyone's help.
Thanks, cr
This is all I'm looking for. As you can see, the result brown, is in the middle of the text if the autofilter criteria works correctly. But as mentioned, correct code should also pull up brown if its the first or last word although I did not include this in the example below.
This is just a simple cell with a lot of text for memo descriptions. Should be easy if wildcard, etc., parameters (*=, etc.) are done correctly.
Note: I know FIND easily does this, but I much prefer Autofilter because it uses much less code and no For Each loop..
I really appreciate anyone's help.
Thanks, cr
Last edited by a moderator:
