|
a543770434 发表于 2016-3-25 09:59
dear 大神
能不能在幫忙在原有的基础上在添加點程序。 - Sub 清除相同内容()
- Dim arr, brr, i&, imax&, A, B, x, n&
- imax = Cells(Rows.Count, 6).End(3).Row
- arr = Range("f2:k" & imax)
- ReDim brr(1 To UBound(arr), 1 To 1)
- For i = 1 To UBound(arr)
- A = arr(i, 1): B = arr(i, 6)
- If Len(B) Then
- B = Split(arr(i, 6), ",")
- For n = 0 To UBound(B)
- brr(i, 1) = Replace(Replace(A, B(n), ""), ",,", ",")
- A = brr(i, 1)
- Next
- x = brr(i, 1)
- If Left(x, 1) = "," Then x = Mid(x, 2)
- If Right(x, 1) = "," Then x = Left(x, Len(x) - 1)
- brr(i, 1) = x
- Else
- brr(i, 1) = A
- End If
- Next
- [n2].Resize(UBound(arr), 1) = brr
- End Sub
复制代码 |
|