|
本帖最后由 duonaohe 于 2011-3-6 15:45 编辑
回复 蓝桥玄霜 的帖子
For i = 2 To UBound(Arr)
If Left(Arr(i, 2), 3) = "禾丰镇" Then
d(Arr(i, 3)) = d(Arr(i, 3)) & i & ","
ElseIf Left(Arr(i - 1, 2), 3) = "禾丰镇" Then
d(Arr(i, 3)) = d(Arr(i, 3)) & i & ","
End If
Next
k = d.keys
t = d.items
ReDim Arr1(1 To UBound(Arr), 1 To 2)
For i = 0 To UBound(k)
t(i) = Left(t(i), Len(t(i)) - 1)
If InStr(t(i), ",") > 0 Then
aa = Split(t(i), ",")
For j = 0 To UBound(aa)
m = m + 1
Arr1(m, 1) = k(i)
Arr1(m, 2) = Arr(aa(j), 2)
Next
End If
Next
能给解释吗?
|
|