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

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