Concatenate using VBA

[huorsa]

I want to concatenate several cell separated by the "|" symbol, I know that in excel this would be: a4=a1&"|"&a2&"|"&a3

How can I do this in VBA??????

Hugo

[Russell Hauf]

On 2002-02-22 17:05, huorsa wrote:
I want to concatenate several cell separated by the "|" symbol, I know that in excel this would be: a4=a1&"|"&a2&"|"&a3

How can I do this in VBA??????

Hugo

try this:

Sub MySub()
    Dim MyString as String

    MyString = Range("A4") & "|" & Range("A5")

    ' ...etc.
    ' Then if you want to put in a cell:

    Range("A1") = MyString
    ' or, combine the 2:
    Range("A1") = Range("A4") & "|" & Range("A5")

End Sub

Hope this helps,

Russell

[ This Message was edited by: Russell Hauf on 2002-02-22 17:16 ]