How to Simplify a offset array

[radar_jynx]

Hi Does any one no how i can simplify this kind of an equation so i dont have to write it for every line Thanxs

,If [B12] = "" Then [E12] = ""
If [B14] = "" Then [E14] = ""
If [B16] = "" Then [E16] = ""
If [B18] = "" Then [E18] = ""
If [B20] = "" Then [E20] = ""
If [B22] = "" Then [E22] = ""
If [B24] = "" Then [E24] = ""
If [B26] = "" Then [E26] = ""
If [B28] = "" Then [E28] = ""
If [B30] = "" Then [E30] = ""
If [B32] = "" Then [E32] = ""
If [B34] = "" Then [E34] = ""
If [B36] = "" Then [E36] = ""
If [B38] = "" Then [E38] = ""
If [B40] = "" Then [E40] = ""
If [B42] = "" Then [E42] = ""
If [B44] = "" Then [E44] = ""
If [B46] = "" Then [E46] = ""
If [B48] = "" Then [E48] = ""
If [B50] = "" Then [E50] = "",

 

[Andrew Poulsom]

Welcome to the Board.

Like this?

For x = 12 To 50 Step 2
    If Range("B" & x).Value = "" Then Range("E" & x).Value = ""
Next x

 

[Norie]

Perhaps this.

For I = 12 To 50 Step 2
      With Range("B" & I)
            If .Value = "" Then .Offset(,3) = ""
      End With
Next I

 

[radar_jynx]

Thanks heaps i used the first one and it works good

Regards