erik.van.geit
MrExcel MVP
- Joined
- Feb 1, 2003
- Messages
- 17,832
Hi, gurus,
JOIN is not available in XL97
a workaround is to loop
or is there something better ?
I didn't find much documentation on this.
Can you point me to some links or do you know a better workaround ?
kind regards,
Erik
JOIN is not available in XL97
a workaround is to loop
or is there something better ?
Code:
Option Explicit
Sub test()
Dim arr(10) As Variant
Dim i As Long
Dim txt As String
For i = 1 To 10
arr(i) = i
Next i
On Error Resume Next
MsgBox "...." & Join(arr, vbLf) & "....", 64, "EXCEL 2000 +"
For i = 1 To 10
txt = txt & vbLf & arr(i)
Next i
MsgBox "...." & txt & "....", 64, "EXCEL 97"
End Sub
Can you point me to some links or do you know a better workaround ?
kind regards,
Erik