Hi all,
IMG1.jpg
I'm trying to divide the items of an array over 3 columns
Like in the image above.
I've tried the following but without succes
![]()
Ar3 = Worksheets("DBS").Range("J2:AD2") j = 1 For i = 1 To UBound(Ar3) If j = 3 Then j = 1 Worksheets("RSTR").Cells(77 + i, 4 + j).Value = Ar3(i, 1) j = j + 1 Next i
Bookmarks