declaring a certain value

Hi,

I'm trying to add to an if statement, saying that if a cell is equal to a certain value, then to ignore it. I'm new to visual basic and I just dont know how to declare that value. I have in bold what I have tried to do.

If ActiveCell.Characters.Count > 13 Or Not only_text(ActiveCell) Or ActiveCell.Value("RM UCONN SFA") Then

Thanks for the help,

-Steve

If ActiveCell.Characters.Count > 13 Or Not only_text(ActiveCell) Or ActiveCell.Value="RM UCONN SFA" Then

Or Ucase(ActiveCell.Value) = "RM UCONN SFA"

--
Regards,
Tom Ogilvy


"thephoenix12" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> I'm trying to add to an if statement, saying that if a cell is equal to
> a certain value, then to ignore it. I'm new to visual basic and I just
> dont know how to declare that value. I have in bold what I have tried
> to do.
>
> If ActiveCell.Characters.Count > 13 Or Not only_text(ActiveCell) *Or
> ActiveCell.Value("RM UCONN SFA") * Then
>
> Thanks for the help,
>
> -Steve
>
>
> --
> thephoenix12
> ------------------------------------------------------------------------
> thephoenix12's Profile:
http://www.excelforum.com/member.php...o&userid=24336
> View this thread: http://www.excelforum.com/showthread...hreadid=382772
>