try.. Sub ptest() Dim e, d#, a# For a = 1 To 2 d = 1 For Each e In Split(Range("A" & a), " ") Cells(3 + a, 1 + d) = e d = d + 1 Next Next End Sub
Sub ptest() Dim e, d#, a# For a = 1 To 2 d = 1 For Each e In Split(Range("A" & a), " ") Cells(3 + a, 1 + d) = e d = d + 1 Next Next End Sub
If the solution helped please donate to RSPCA Site worth visiting: Rabbitohs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks