|
发表于 2017-6-7 14:39
|
显示全部楼层
本楼为最佳答案
- Private Sub CommandButton1_Click()
- Dim arr, brr
- Set d = CreateObject("Scripting.Dictionary")
- arr = Worksheets("購入先リスト").[A2].CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = ""
- Next
- brr = Worksheets("sheet1").Range("F10:F" & Worksheets("sheet1").Cells(Rows.Count, 6).End(3).Row)
- For i = 1 To UBound(brr)
- If brr(i, 1) <> "" Then
- If d.exists(brr(i, 1)) Then
- i = i
- Else
- Worksheets("sheet1").Cells(i + 9, 6).Interior.ColorIndex = 6
- End If
- End If
- Next
- End Sub
复制代码
|
评分
-
查看全部评分
|