I am trying to create a textjoin macro that will recombine sorted words from a range of columns. The textjoin statement works in a single cell, but when I try to put it in a macro, I get a "syntax error" statement.
The macro code is:
Thanks. Any help is greatly appreciated.
The macro code is:
Code:
Public Sub rejoinJ()
Dim i As Long
Dim lRow As Long
lRow = Cells(Rows.Count, 1).End(xlUp).Row
Dim curRow As Long
curRow = 1
For i = curRow To lRow
TEXTJOIN(" ", TRUE, "N" & curRow & ":BA" & curRow)
' MsgBox curRow
curRow = curRow + 1
Next i
End Sub
Thanks. Any help is greatly appreciated.