- Private Sub CommandButton2_Click()
- Dim arr, dic
- Dim xcolor&, x&, j&, i&, lrow&, xRow&
- Application.ScreenUpdating = False
- xRow = Range("x65536").End(xlUp).Row
- Set dic = CreateObject("scripting.dictionary")
- For i = 2 To xRow
- xcolor = Cells(i, 23).Interior.ColorIndex
- x = Cells(i, 24)
- dic(xcolor) = x
- Next
- lrow = Range("a65536").End(xlUp).Row
- ReDim arr(1 To lrow, 1 To 10)
- For i = 1 To lrow
- For j = 1 To 10
- arr(i, j) = dic(Cells(i, j).Interior.ColorIndex)
- Next
- Next
- [A1].Resize(lrow, 10) = arr
- Application.ScreenUpdating = True
- End Sub
复制代码 |