Need help with if then statement

S

Shani

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
 
S

Steve Rindsberg

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
Click to expand...

If [condition] Then
statement
statement
statement
End If

So

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

There's more you can do along the same lines. Try the help file.
 
Top