Comparison operator

[Pawan]

Hi...

My code is:

If Cells(rw, colno).Value = "US" Or _
Cells(rw, colno).Value = "AI" Then
With Cells(rw, colno)

If UserForm1.ch_sensrtype_d.Value = False Then
.Value = UserForm1.sensrtype.Value
Else
.Value = sensrtype_d
End If
ENd IF

In the line
Cells(rw, colno).Value = "AI", I am comapring cell value with "AI".
However, here I want to search if any part of the cell contains "AI". Measn,
if my cell has value "AIT", then also this statement should become true.

I tried writing "*" & "AI" & "*" but it doesnt work. How can I do this?

Regards,

Pawan

 

[Bob Phillips]

If Cells(rw, colno).Value = "US" Or _
Cells(rw, colno).Value Like "*AI*" Then


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pawan]

Thanks Bob...

I have onem ore doubt in this. My macro is searching for "US" (i.e.
Uppercase). If there is "us" in some cells, its not working. Can we make it
work?

Regards,
Pawan

 

[Bob Phillips]

If LCase(Cells(rw, colno).Value) = "us" Or _
Cells(rw, colno).Value Like "*AI*" Then

this will work for us, US, Us, or uS, that is it is non case-sensitive.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pawan]

Great.. Thanks Bob..!

If LCase(Cells(rw, colno).Value) = "us" Or _
Cells(rw, colno).Value Like "*AI*" Then

this will work for us, US, Us, or uS, that is it is non case-sensitive.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)