Hi. I'm trying to use a code found on this site https://www.extendoffice.com/documents/excel/3269-excel-concatenate-cells-if-not-empty.html
Unfortunately, when I try to execute it gives me the "can't find project or library" error. What could be the problem? It also briefly highlights the first "n" in blue before pointing to the first line of the code. Thanks in advance for any help.
Unfortunately, when I try to execute it gives me the "can't find project or library" error. What could be the problem? It also briefly highlights the first "n" in blue before pointing to the first line of the code. Thanks in advance for any help.
Code:
Function Concatenatecells(ConcatenateArea As Range) As String
'updateby Extendoffice 20151103
For Each n In ConcatArea: nn = IIf(n = "", nn & "", nn & n & "/"): Next
Concatenatecells = Left(nn, Len(nn) - 1)
End Function