|
本帖最后由 today0427 于 2016-10-2 22:50 编辑
- Sub gx()
- Dim arr, brr(), i&, j%, s, n&
- arr = Sheets("sheet1").[a1].CurrentRegion
- For Each s In Sheets
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- If s.Name <> "Sheet1" Then
- s.UsedRange.Clear
- For i = 1 To UBound(arr)
- If i = 1 Or arr(i, 2) Like "*" & s.Name & "*" Then
- n = n + 1
- For j = 1 To UBound(arr, 2)
- brr(n, j) = arr(i, j)
- Next
- End If
- Next
- s.[a1].Resize(n, j - 1) = brr
- Erase brr: n = 0
- End If
- Next
- End Sub
复制代码
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
评分
-
查看全部评分
|