ActiveCell = " < "

[Ctech]

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?

[GB]

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
>
>