|
如附件要求。。能把附件中的A列单元格中数值为a的选出来,放在最后个表中,,求解。。。
看看吧,个人测试没问题,你测试下 - Sub 提取a()
- Dim sht As Worksheet, hb_sht As Worksheet, rg As Range, n As Integer
- Dim add
- n = 1
- Application.ScreenUpdating = False
- On Error Resume Next
- Set hb_sht = Sheets("合并含a")
- For Each sht In Sheets
- If sht.Name <> "合并含a" Then
- Set rg = sht.Range("A:A").Find("a", , , xlWhole)
- If Not rg Is Nothing Then
- add = rg.Address
- Do
- rg.EntireRow.Resize(3).Copy hb_sht.Range("A" & n)
- n = n + 4
- Set rg = sht.Range("A:A").FindNext(rg)
- Loop Until rg.Address = add
- End If
- End If
- Next
- On Error GoTo 0
- Application.ScreenUpdating = True
- End Sub
复制代码
1111 (自动保存的).zip
(12.25 KB, 下载次数: 12)
|
|