ExcelPowerUser
Sunday, December 25, 2011
JOIN
its a method to concatenation values in a string variable , you can use this trick to avoid a Loop for this purpose.
Sub MakeString()
Dim strSting As String
strSting = Join(Application.Transpose(Selection), ",")
Debug.Print strSting
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment