I have put the VBA below into a module in an excel table. When I exit editor, when I start typing =textjoin it recognises the formula but the when I type =TEXTJOIN(";",TRUE,KQ8:KS8) I get "#NAME?"
Any idea why?
Dim RangeArea As Variant Dim Cell As Range 'Loop Through Each Cell in Given Input For Each RangeArea In Text1 If TypeName(RangeArea) = "Range" Then For Each Cell In RangeArea If Len(Cell.Value) <> 0 Or Ignore_Empty = False Then TEXTJOIN = TEXTJOIN & Delimiter & Cell.Value End If Next Cell Else 'Text String was Entered If Len(RangeArea) <> 0 Or Ignore_Empty = False Then TEXTJOIN = TEXTJOIN & Delimiter & RangeArea End If End If Next RangeArea TEXTJOIN = Mid(TEXTJOIN, Len(Delimiter) + 1) End Function
Bookmarks