本帖最后由 1055751654 于 2019-11-4 20:46 编辑
不厉害,我想一下把李四王二麻子也弄出来,弄出来了,虽然代码打的烂,但也要保持S形的身材
Sub 傻不愣登的代码()
Dim arr, i, b, brr(1 To 100, 1 To 3), bb, xx
[j3:r100].ClearContents
arr = Range("a1").CurrentRegion
For i = 3 To UBound(arr)
If Cells(i, 3) Like "*张三*" Then
b = b + 1
brr(b, 1) = arr(i, 1)
brr(b, 2) = arr(i, 4)
brr(b, 3) = arr(i, 5)
End If
If Cells(i, 6) Like "*张三*" Then
b = b + 1
brr(b, 1) = arr(i, 1)
brr(b, 2) = arr(i, 7)
brr(b, 3) = arr(i, 8)
End If
Next
[j3].Resize(b, 3) = brr
For i = 3 To UBound(arr)
If Cells(i, 3) Like "*李四*" Then
bb = bb + 1
brr(bb, 1) = arr(i, 1)
brr(bb, 2) = arr(i, 4)
brr(bb, 3) = arr(i, 5)
End If
If Cells(i, 6) Like "*李四*" Then
bb = bb + 1
brr(bb, 1) = arr(i, 1)
brr(bb, 2) = arr(i, 7)
brr(bb, 3) = arr(i, 8)
End If
Next
[m3].Resize(bb, 3) = brr
For i = 3 To UBound(arr)
If Cells(i, 3) Like "*王二麻子*" Then
xx = xx + 1
brr(xx, 1) = arr(i, 1)
brr(xx, 2) = arr(i, 4)
brr(xx, 3) = arr(i, 5)
End If
If Cells(i, 6) Like "*王二麻子*" Then
xx = xx + 1
brr(xx, 1) = arr(i, 1)
brr(xx, 2) = arr(i, 7)
brr(xx, 3) = arr(i, 8)
End If
Next
[p3].Resize(xx, 3) = brr
End Sub
|