Join [Vba Method]

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

One Comment Add yours

  1. da says:

    Its like you learn my mind! You seem to understand
    so much approximately this, like you wrote the guide in it or something.
    I feel that you could do with a few % to power the message house a little bit, but instead of that, that is wonderful blog. A fantastic read. I will certainly be back.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s