|
- Sub 拆分2()
- Dim iCol&, rg As Range, a As Worksheet, wbname$
- Worksheets("sheet1").Activate
- Application.ScreenUpdating = False
- On Error Resume Next
- With Worksheets("sheet1")
- Set rg = .Range("e3")
- iCol = rg.Column
- Do While iCol <> Columns.Count
- wbname = rg.Offset(, 2).Value
- Debug.Print wbname, iCol
- Set a = Worksheets(wbname)
- If a Is Nothing Then
- Worksheets.Add after:=Worksheets(Worksheets.Count)
- ActiveSheet.Name = wbname
- .Range("a:c").Copy Range("a1")
- .Columns(rg.Column).Resize(, 5).Copy Range("d1")
- End If
- Set rg = rg.End(xlToRight)
- iCol = rg.Column
- Set a = Nothing
- Loop
- End With
- Worksheets("sheet1").Activate
- Application.ScreenUpdating = True
- MsgBox "拆分完毕"
- End Sub
复制代码 |
评分
-
查看全部评分
|