|
本帖最后由 文轩馨婷 于 2015-1-8 18:43 编辑
代码解释(14年可以用到了15年就不行了)我该怎么改??
求助求助!!!(顺便帮忙解释一下红色字体的中文意思!!)
Sub 汇总数据()
Dim arr, er(), x, k, d, rq
On Error GoTo m
Set d = CreateObject("scripting.dictionary")
arr = Sheets("北海出货明细").Range("A1").CurrentRegion.Offset(1)
ReDim er(1 To UBound(arr), 1 To 5)
For x = 1 To UBound(arr)
rq = Year(Date) & "-" & Sheet1.[F2]
If Format(arr(x, 1), "yyyy-m") = rq Then
If d.exists(arr(x, 2)) Then
er(d(arr(x, 2)), 4) = er(d(arr(x, 2)), 4) + arr(x, 6)
Else
k = k + 1
d(arr(x, 2)) = k
er(k, 1) = arr(x, 2)
er(k, 2) = arr(x, 3)
er(k, 3) = arr(x, 7)
er(k, 4) = arr(x, 6)
er(k, 5) = arr(x, 8)
End If
End If
Next
With Range("a3")
.Resize(k + 50, 5).Value = ""
.Resize(k, 5).Value = er
End With
Exit Sub
m: MsgBox "您选的月份尚未出货", 1 + 64, "温馨提示"
End Sub
{:251:}
|
|