Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help !!!
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help !!!
Not sure what you need
=A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7&","& A8&","&A9&","&A10 "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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help !!!
Thanks I found a work arround
"Gary''s Student" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|