If Cells(i,,j) Like "*" &Cells(i,k) & "*" Then
t=g
m=3
var=6
End If


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Shani" wrote in message
oups.com...
I want more than one actions to be carried out for and if statement.

So for example

If Cells(i,,j) "*Like*" Cells(i,k) Then t=g and m=3 and var=6


The above statement dosnt work. can you please help me witht he syntax