可以参考如下帖子:
http://club.excelhome.net/thread-917959-1-1.html
1 nm = Array("Sheet1", "Sheet2", "Sheet3") 2 For i = 0 To UBound(nm) 3 Sheets(nm(i)).Copy after:=Workbooks(newwjm).Sheets(Sheets.Count) 4 Next
posted on 2020-02-19 11:01 搞笑机械师 阅读(338) 评论(0) 编辑 收藏 举报