Sub test()
Dim i
Dim arr
Dim rarr(1 To 100, 1 To 1)
arr = Sheets(2).Range("g1").CurrentRegion
For i = 1 To UBound(arr)
If arr(i, 1) = 3 And Sheets(2).Range("G" & i).Interior.ColorIndex = Sheets(2).Range("i4").Interior.ColorIndex Then
k = k + 1
rarr(k, 1) = Sheets(2).Range("A" & i)
End If
Next
Range("a1").Resize(k, 1) = rarr
End Sub
Sub test()
Dim i, irow
irow = Cells(Rows.Count, "g").End(xlUp).Row
For i = irow To 1 Step -1
If Range("G" & i).Interior.ColorIndex = Range("c1").Interior.ColorIndex Then
Range("G" & i).ClearContents
End If
Next
End Sub
Sub test()
Dim i
Dim arr
Dim rarr(1 To 100, 1 To 1)
arr = Sheets(2).Range("g1").CurrentRegion
For i = 1 To UBound(arr)
If arr(i, 1) = 3 And Sheets(2).Range("G" & i).Interior.ColorIndex = Sheets(2).Range("i4").Interior.ColorIndex Then
k = k + 1
rarr(k, 1) = Sheets(2).Range("A" & i)
End If
Next
Range("a1").Resize(k, 1) = rarr
End Sub