PDA

View Full Version : Solved: comparing text to cells but only partial match



Regouin
05-24-2005, 06:33 AM
i have the following


If RangeAI.Value = cell.Value Or RangeAI.Value = "0000" Then
NotEqual = False
End If


How do i chance the second bit so that it doesnt just hit on the entire string but also when it is only a partial hit? I know how to do that with find, but not with the value thing.

probably a stupid question, but i really cant find the answer.

TIA Frank

xld
05-24-2005, 06:42 AM
i
If RangeAI.Value = cell.Value Or RangeAI.Value = "0000" Then
NotEqual = False
End If


How do i chance the second bit so that it doesnt just hit on the entire string but also when it is only a partial hit? I know how to do that with find, but not with the value thing.


If RangeAI.Value = cell.Value Or RangeAI.Value Like "*0000*" Then
NotEqual = False
End If

Regouin
05-24-2005, 06:44 AM
thanks, i was so close

tried


RangeAI.Value Like "0000"


and tried


RangeAI.Value = "*0000*"


but didnt think of comparing them, it works beautifully thanks.

Frank