Public Function StringNum(Rng As Range) As String Dim tmpStr As String
tmpStr = ""
For Each cell In Rng
tmpStr = tmpStr & cell.Value & ","
Next
StringNum = Mid(tmpStr, 1, Len(tmpStr) - 1)
End Function