Syntax
Public Function JoinArray(sourceArry As Variant, Optional Delimeter As String) As String
Description
This function is used to return a string created by joining a number of substrings contained in any array.
Parameters
Key | Description |
sourceArry | One-dimensional array containing substrings to be joined. |
Delimeter | Any string used to separate the substrings in the returned string, value of type String |
Return value
Returns a string value.
Exceptions
Error number | Condition |
5 | sourceArry is not one dimensional; |
Sample
Public Sub main () Dim Arr CopyHigh 0, 10, 10, Arr MsgBox JoinArray (arr,"/") End sub
See Also