|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 工作表拆分() '通过筛选方法完成需求,速度快,但当有合并单元格时就不能用。读者可以根据实际情况选用
- Application.ScreenUpdating = False '关闭屏幕更新,加快执行速度
- Dim sh As Worksheet, r&, i&
- Set sh = Sheets("sheet1")
- With sh
- r = .Cells(Rows.Count, 3).End(xlUp).Row
- Worksheets.Add , sh, r - 1
- For i = 2 To r
- Union(.[a1], .Cells(i, 1)).EntireRow.Copy Sheets(i).[a1]
- .UsedRange.EntireColumn.Copy
- With Sheets(i)
- .Select
- .[a1].PasteSpecial 8, xlNone
- .[c2] = "'" & .[c2].Text
- .Name = Replace(Replace(sh.Cells(i, 3).Text, "(", ""), ")", "")
- End With
- Next
- End With
- Application.ScreenUpdating = True '恢复屏幕更新
- MsgBox "拆分完毕!", 64, "友情提示"
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|