|
- Sub today()
- Dim arr, d As Object, i&, brr
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("2ÄáÏÃû3Æ").Range("b2:c" & Sheets("2ÄáÏÃû3Æ").[c65536].End(3).Row)
- For i = 1 To UBound(arr)
- d(arr(i, 2)) = arr(i, 1)
- Next
- With Sheets("éú2ú¼Æ»®í3¼ÆÃ÷ϸ±í")
- brr = .Range("a7:b" & .[a65536].End(3).Row)
- For i = 1 To UBound(brr)
- brr(i, 2) = d(brr(i, 1))
- Next
- .[b7].Resize(i - 1, 1) = Application.Index(brr, , 2)
- End With
- End Sub
复制代码 |
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
评分
-
查看全部评分
|