|
- Sub Macro1()
- Dim arr, sht As Worksheet, i&, zf$$
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- arr = ActiveSheet.UsedRange
- Set sht = ThisWorkbook.Sheets(1)
- For i = 1 To UBound(arr)
- If arr(i, 1) Like "注释:*" Then
- zf = Split(arr(i, 1), "注释:")(1)
- With Workbooks.Add
- sht.Cells(i, 1).CurrentRegion.Copy .Sheets(1).[a1]
- .SaveAs Filename:=ThisWorkbook.Path & "" & zf & ".xls"
- Workbooks(zf).Close 1
- End With
- End If
- Next
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|