# How to Simplify a offset array

##### New Member
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] = "",

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### Andrew Poulsom

##### MrExcel MVP
Welcome to the Board.

Like this?

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

#### Norie

##### Well-known Member
Perhaps this.
Code:
``````For I = 12 To 50 Step 2
With Range("B" & I)
If .Value = "" Then .Offset(,3) = ""
End With
Next I``````

##### New Member
Thanks heaps i used the first one and it works good

Regards

Replies
6
Views
349
Replies
12
Views
464
Replies
8
Views
305
Replies
0
Views
1K
Replies
4
Views
366

1,195,989
Messages
6,012,716
Members
441,722
Latest member
tpaman1975

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back