本帖最后由 爱疯 于 2012-7-11 16:24 编辑
今天使用Join函数时,居然报错,经试验后发现,原来Join函数对其sourcearray参数的元素类型是有要求的,我理解为它支持的数组元素类型只能是字符串类型和Variant类型。 Option Explicit
' 1. 字符串数组可以Join Sub JoinArrString() Dim arr(1 To 2) As String arr(1) = "1" arr(2) = "2" Debug.Print "JoinArrString:" & Join(arr, ",") End Sub
' 2. Vaiant数组可以Join Sub JoinArrVariant() Dim arr(1 To 2) arr(1) = 1 arr(2) = 2 Debug.Print "JoinArrVariant:" & Join(arr, ",") End Sub
' 3. Vaiant(实际返回Variant元素类型数组)可以Join Sub JoinVariant() Dim arr arr = Array(1, 2) Debug.Print "JoinVariant:" & Join(arr, ",") End Sub
' 4. 数值型(含布尔型)数组不可以Join Sub JoinArrLong() Dim arr(1 To 2) As Long arr(1) = 1 arr(2) = 2 Debug.Print "JoinArrLong:" & Join(arr, ",") End Sub
[此贴子已经被作者于2010-9-29 12:46:35编辑过] |