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


--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile: http://www.excelforum.com/member.php...o&userid=24336
View this thread: http://www.excelforum.com/showthread...hreadid=382772

declaring a certain value
 

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

--
Regards,
Tom Ogilvy


"thephoenix12"
wrote in message
...

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

declaring a certain value
 

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

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38277