For i = 3 To .Cells(65536, 3).End(xlUp).Row
If .Cells(i, 4) <> 1 Then
brr = Split(.Cells(i, 3), ",")
ReDim arr(UBound(brr))
For j = 0 To UBound(brr())
arr(j) = Val(brr(j))
Next j
ReDim crr(1 To UBound(brr()) - LBound(arr()) + 1)
For j = 1 To UBound(crr())
crr(j) = Application.WorksheetFunction.Small(arr(), j)
Next j
.Cells(i, 3) = crr(1)
For j = 2 To UBound(crr())
.Cells(i, 3) = .Cells(i, 3) & "," & crr(j)
Next j
End If
Next i
这只是一部分代码,但是一运行到这段代码时,当字母与数字多个组合时为0了
纯数字就没事,单个组合也没事
0,0
0,0
0,0
C10
0,0
R8
0,0本来应该是R1,R2之类的东东!
请高手指点,谢谢!!!
如有兴趣加QQ:107172400!有文档详聊!