If you use a InStr comparison function you can resolve if the < is in there.
InStr(ActiveSheet.Cells(RowLocation, ColLocation).Text, "<")
Look in the help files to see what kind of returns you get, but you should
be able to evaluate it for existence of "<" from there.
"Ctech" wrote:
Hi
Im trying to make a macro that if ActiveCell = "<"
How can I make the macro take all cells that contains the sign < :
so <5454 and Cake< will two examples:
how can I do this?
--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=501076