Private Function SetDic(dic As Scripting.Dictionary, sN As String) As Scripting.Dictionary
If Not dic.Exists(sN) Then
dic.Add sN, 16
Worksheets("main1").Copy After:=Worksheets(Worksheets.Count)
ActiveSheet.Name = sN
Else
dic.Item(sN) = dic.Item(sN) + 1
End If
Set SetDic = dic
End Function
田中 宏明さんの投稿
(投稿ID: 3948)