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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com