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