|
楼主 |
发表于 2016-11-19 06:20
|
显示全部楼层
你好大师,如果我增加了几列之后表格如图这样
那么我要在原先的VBA代码如何更改呢
原VBA代码是如下
Sub lqxs()
Dim Arr, i&, x$, s$, j&
[g4].Resize(5000, 3).ClearContents
Arr = [a1].CurrentRegion
For j = 7 To UBound(Arr, 2)
x = Arr(3, j): s = ""
For i = 2 To UBound(Arr)
If Arr(i, j - 3) = x Then s = s & i & ","
Next
If s <> "" Then
s = Left(s, Len(s) - 1): n = 4
If InStr(s, ",") Then
aa = Split(s, ",")
For y = UBound(aa) To 0 Step -1
Cells(aa(y) + 1, j - 3).Resize(30, 1).Copy Cells(n, j): n = n + 30
Next
Else
Cells(s + 1, j - 3).Resize(30, 1).Resize(30, 1).Copy Cells(n, j): n = n + 30
End If
End If
Next
End Sub
|
|