I am getting a compile error: expected expression. No line is highlighted XD
Sub name()
Dim arr() As String
Dim lastRow As Long
c = 2
With ActiveSheet
lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = 1 To lastRow
arr = Split(.Cells(i, 1), " ")
For Each e In arr
.Cells(i, c).Value = arr(e)
c = c + 1
Next
Set arr = Empty
Next
End With
End Sub
As @gtwebb stated the name was the main issue.
There were a couple other minor thing I found will debugging: