|
楼主 |
发表于 2022-1-24 12:20
|
显示全部楼层
你好,就是这段代码,在筛选状态时就会出现单元格内容错位,请帮我修改一下,谢谢!
Sub 莱Μ眀蹿_癸()
Dim Arr, xD, T$, i&, Brr
Set xD = CreateObject("Scripting.Dictionary")
Arr = Sheet1.[a3].CurrentRegion '緇肂戈杆计舱
For i = 2 To UBound(Arr)
T = Arr(i, 1): xD(T) = Array(T, Arr(i, 4), Arr(i, 5)) 'xD:紅坝穨叭蛤虫
Next
Arr = Sheet2.Range([v3], [a65536].End(3)) '莱Μ眀蹿灿戈杆计舱
ReDim Brr(1 To UBound(Arr), 1 To 4)
For i = 1 To UBound(Arr)
Arr(i, 17) = Val(Arr(i, 15)) + Val(Arr(i, 16)) '蹿肂+キ眀肂
T = Arr(i, 3)
If xD.Exists(T) Then '絋粄めΤ礚
Brr(i, 1) = xD(T)(1) '蹲穨叭戈
Brr(i, 2) = xD(T)(2) '蹲蛤虫戈
Brr(i, 3) = xD(T)(0) '蹲紅坝戈
Brr(i, 4) = Month(Arr(i, 1)) 'る
End If
Next
Sheet2.Range("s3").Resize(UBound(Arr), 4) = Brr 'Brr蹲[a3]
End Sub
|
|