check contain value with macro
 

Is there a way to check if activeCell.Value contain this “12ab44”.
need that it equal a Boolean (true false)

ex:

if ActiveCell.Value = "12ab44" then
test1
end i

--
Nadia2
-----------------------------------------------------------------------
Nadia25's Profile: http://www.excelforum.com/member.php...fo&userid=2757
View this thread: http://www.excelforum.com/showthread.php?threadid=47099

check contain value with macro
 

Maybe

If ActiveCell.Value Like "*12ab44*" Then
test1
End If

hope this helps
Rowan

Nadia25 wrote:
Is there a way to check if activeCell.Value contain this “12ab44”. I
need that it equal a Boolean (true false)

ex:

if ActiveCell.Value = "12ab44" then
test1
end if