Help !!!
How about:
Function string_them(s As String) As String
Dim ss As String
Set rr = Range(s)
ss = ""
cma = True
For Each r In rr
If cma = True Then
cma = False
ss = r.Value
Else
ss = ss & "," & r.Value
End If
Next
string_them = ss
End Function
In a worksheet cell enter:
=string_them("marco")
You should use CONCATENATE if you don't need to refer to that Named Range.
--
Gary''s Student - gsnu200719
"MESTRELLA29" wrote:
I need a formla that could return the values of a name range,
Example name range is "marco" and takes cells A1:A10
A1= 9901 Text
A2= 9902 Text
A3= 9903 Text
.
.
.
I need the formula to return as 9901,9902,9903...
did I make my self clear?
|