VB:If cl.Value Like "*-*" Then
i just need to find cells containing a certain character. It can be anywhere in the cell. The character is -
If cl.Value = "=*-*" Then
If cl.Value = "=-*" Then
If cl.Value = "*-*" Then
If cl.Value = "*-" Then
If cl.Value = "=*-" Then
Im not sure what the right format is, ive searched cant find it.
ps i can If cl.Value = "P-X1B" Then
and the rest of my code and get it to work just fine...
thanks
VB:If cl.Value Like "*-*" Then
Christos Lepesiotis
awesome thanks!Originally Posted by clepe
how would i do that if i want it to be NOT like
If I understand correct
VB:If cl.Value Like "*-*" Then 'execute code for "-" existance Else 'execute code for "-" NOT existance End If
Christos Lepesiotis
A much easier way to not include something is with <> instead of an equal sign. I just figured that out figured i would add back to this post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks