Compare cell value with string
 

When you use not equal you have to use and. With Or what you are saying is if
not equal to one or not equal to the other therefore so long as one is not
equal then it is true.

If (Cells(loop_counter, "B").Value < "SoftwaInternal" and
Cells(loop_counter, "B").Value < "SoftwaTest Fixed Fee") Then

--
Regards,

OssieMac


"Shahriar Nour Khondokar" wrote:

Hi all
I am trying to compare (and identify) the values in a column with 2 strings.
i am using the following code:
If (Cells(loop_counter, "B").Value = "SoftwaInternal" Or
Cells(loop_counter, "B").Value = "SoftwaTest Fixed Fee") Then

...
End If
'loop_counter' is a variable that has been declared.
This piece of code does its job and identifies cell in column-B that have
"SoftwaInternal" and "SoftwaTest Fixed Fee" as value.

But when i try to use the code below to identify the cells that do NOT have
"SoftwaInternal" and "SoftwaTest Fixed Fee" as Value, it is not working:
If (Cells(loop_counter, "B").Value < "SoftwaInternal" Or
Cells(loop_counter, "B").Value < "SoftwaTest Fixed Fee") Then

...
End If

Can someone please help me understand why is this not working and what can i
use to get the desired result?

Thanks for you help.

Compare cell value with string
 

Thanks all for your help!

It was a logic problem as opposed to a syntactical problem; i had to replace
the OR with AND.
I am new to VBA and still need to gain confidence with the syntax :-)

"OssieMac" wrote:

When you use not equal you have to use and. With Or what you are saying is if
not equal to one or not equal to the other therefore so long as one is not
equal then it is true.

If (Cells(loop_counter, "B").Value < "SoftwaInternal" and
Cells(loop_counter, "B").Value < "SoftwaTest Fixed Fee") Then

--
Regards,

OssieMac


"Shahriar Nour Khondokar" wrote:

Hi all
I am trying to compare (and identify) the values in a column with 2 strings.
i am using the following code:
If (Cells(loop_counter, "B").Value = "SoftwaInternal" Or
Cells(loop_counter, "B").Value = "SoftwaTest Fixed Fee") Then

...
End If
'loop_counter' is a variable that has been declared.
This piece of code does its job and identifies cell in column-B that have
"SoftwaInternal" and "SoftwaTest Fixed Fee" as value.

But when i try to use the code below to identify the cells that do NOT have
"SoftwaInternal" and "SoftwaTest Fixed Fee" as Value, it is not working:
If (Cells(loop_counter, "B").Value < "SoftwaInternal" Or
Cells(loop_counter, "B").Value < "SoftwaTest Fixed Fee") Then

...
End If

Can someone please help me understand why is this not working and what can i
use to get the desired result?

Thanks for you help.