Help !!!

M

MESTRELLA29

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?
 
M

Mike

Not sure what you need
=A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7&","&A8&","&A9&","&A10
 
G

Gary''s Student

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.
 
M

MESTRELLA29

Thanks I found a work arround

Gary''s Student said:
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.
Click to expand...
 
Top