What is the syntax to return a string made from substrings?

Join(list, delimiter)
‘list – array containing the subscripts to be joined; mandatory parameter
‘dlimiter – optional parameter with default being space
‘example
Dim grades() As Variant
grades = Array(87, 56, 99, 77)
MsgBox (Join(grades)) 'returns 87 56 99 77
MsgBox (Join(grades, " || ")) 'returns 87 || 56 || 99 || 77

 

 

Advertisements