|
楼主 |
发表于 2017-5-31 14:01
|
显示全部楼层
Sub 把这个代码改写数组()
Dim arr, i&, j&, c, m
arr = [a2:o7]
ReDim brr(1 To 6)
For i = 1 To 6
c = ""
m = 0
For j = 1 To 15
If arr(i, j) <> "" Then
c = c & "," & arr(i, j)
m = m + 1
End If
Next
If m <= 6 Then
brr(i) = Right(c, Len(c) - 1) & "/0~1~2~3"
Else
brr(i) = Right(c, Len(c) - 1) & "/1~2~3"
End If
Next
[q2:q7] = Application.Transpose(brr)
End Sub
|
|