Compare cell value with string
 

Hi,

Try replacing your 'Or' with 'And':
If (Cells(loop_counter, "B").Value < "SoftwaInternal" And _
Cells(loop_counter, "B").Value < "SoftwaTest Fixed Fee") Then
....
End If

Alternatively, since you're already testing with you might as well use:
If (Cells(loop_counter, "B").Value = "SoftwaInternal" Or _
Cells(loop_counter, "B").Value = "SoftwaTest Fixed Fee") Then
....
Else
....' insert your negative response here
End If

--
Cheers
macropod
[Microsoft MVP - Word]


"Shahriar Nour Khondokar" wrote in message
...
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.