我有一个包含多个工作表的 Excel 文档。当我从第一张纸返回到第二张纸后运行循环跳转时。但在第二张纸上没有打开新字典,并且我在 ln 16 处收到类似“运行时错误 9”的错误。MySeries(Cnt, 2) = Dt(j, 2)
新词典打开时的每张纸我可以做什么?
Dim Cll As Object
Dim j As Integer
Dim y As Integer, MySeries, Dt, MySeries1, MySeries2, MySeries3, MySeries4 As Integer, sum As Double
For y = 1 To (Worksheets.Count - 1)
Sheets(y).Select
Ln = Sheets(y).Range("a1").End(4).Row
Sheets(y).Range("d2:H" & Ln).Interior.ColorIndex = xlNone
Dt = Sheets(y).Range("d2:h" & Ln).Value
Set Cll = CreateObject("Scripting.Dictionary")
ReDim MySeries(1 To Ln, 1 To 5)
For j = 1 To UBound(Dt, 1)
Fnd = Dt(j, 1)
If Not Cll.exists(Fnd) Then
Cnt = Cnt + 1
Cll.Add Fnd, Cnt
ReDim Preserve MySeries(1 To Ln, 1 To 5)
MySeries(Cnt, 1) = Dt(j, 1)
MySeries(Cnt, 2) = Dt(j, 2)
MySeries(Cnt, 3) = Dt(j, 3)
MySeries(Cnt, 4) = Dt(j, 4)
End If
MySeries(Cll.Item(Fnd), 5) = MySeries(Cll.Item(Fnd), 5) + Dt(j, 5) / 1000
Next j
Sheets(y).Range("a2:h" & Ln).Clear
Sheets(y).Range("d2").Resize(Cll.Count, 5) = MySeries
Next y
感谢您的帮助