知识点:字典,主要是item中可以是union(),并进行复制
======代码如下=======
Sub 在一个工作簿内把总表拆分多个工作表()
Dim title_rng As Range,...)
endrow = Cells.Find("*", Cells(1, 1), xlValues, xlWhole, xlByRows, xlPrevious).Row '计算最后一个工作表的非空行号...dic1(s), .Cells(i, 1).Resize(1, endCol))
End If
Debug.Print i
Next i
MsgBox "将拆分出工作表数有...End With
For Each k In dic1.Keys
With ThisWorkbook.Sheets.Add
title_rng.Copy....Range("a1")
dic1(k).Copy .Range("a2")
.Name = k
End With
Next