Sleeper: Like Function

[Dreamer]

HI all,

I know that if I want to search for a string which contains a word e.g car,
then I can use like function.. if xTemp.value like "*car*" then......
however, I want to search for any row which contains exactly the symbol "*",
how should I write? " if xTemp.value like "*" then...." is not working...

Thanks a lot!

[MWE]

HI all,

I know that if I want to search for a string which contains a word e.g car,
then I can use like function.. if xTemp.value like "*car*" then......
however, I want to search for any row which contains exactly the symbol "*",
how should I write? " if xTemp.value like "*" then...." is not working...

Thanks a lot!
Since you are searching for "text", it might make more sense to use xTemp.Text instead of xTemp.Value

Something like


If xTemp.Text = "*" then

should work

I am assuming that you have declared xTemp as a Range and set xTemp = to the target cell or something similar

[Bob Phillips]

HI all,

I know that if I want to search for a string which contains a word e.g car,
then I can use like function.. if xTemp.value like "*car*" then......
however, I want to search for any row which contains exactly the symbol "*",
how should I write? " if xTemp.value like "*" then...." is not working...

Thanks a lot!

Like "*
*"

.