Function CombineArray(ByVal sArray1, ByVal sArray2, Optional Sep As String = "")
Dim tmpArr1, tmpArr2, Arr() As String, aResult(), Item1, Item2, tmp
Dim lR As Long, i As Long
On Error Resume Next
If IsArray(sArray1) Then
tmpArr1 = sArray1
Else
ReDim tmpArr1(1 To 1, 1 To 1)
tmpArr1(1, 1) = sArray1
End If
If IsArray(sArray2) Then
tmpArr2 = sArray2
Else
ReDim tmpArr2(1 To 1, 1 To 1)
tmpArr2(1, 1) = sArray2
End If
For Each Item1 In tmpArr1
If CStr(Item1) <> "" Then
For Each Item2 In tmpArr2
If CStr(Item2) <> "" Then
lR = lR + 1
ReDim Preserve Arr(1 To lR)
tmp = Item2 & Sep & Item1
Arr(lR) = tmp
End If
Next
End If
Next
If lR Then
ReDim aResult(1 To UBound(Arr), 1 To 1)
For i = 1 To UBound(Arr)
aResult(i, 1) = Arr(i)
Next
CombineArray = aResult
End If
End Function