|
这功能强大Public Function ConTxt(ParamArray args() As Variant) As Variant '????
Dim tmptext As Variant, i As Variant, cellv As Variant
Dim cell As Range
tmptext = "" '?????????,????????
For i = 0 To UBound(args) '??????????
If Not IsMissing(args(i)) Then '??????????,????????
Select Case TypeName(args(i)) '??????,????????????
Case "Range" '????????????
For Each cell In args(i)
tmptext = tmptext & cell
Next cell
Case "Variant()" '???,???????????????,?????
For Each cellv In args(i)
tmptext = tmptext & cellv
Next cellv
Case Else '???,??????????????,?????
tmptext = tmptext & args(i)
End Select
End If
Next i
ConTxt = tmptext
End Function
出来就是数组格式 |
|