Sub Test()
Dim cel As Range, aa As Range
For Each cel In Range("A:B")
If cel.Interior.ColorIndex = 1 Then
If aa Is Nothing Then Set aa = cel Else Set aa = Union(aa, cel)
End If
Next
If Not aa Is Nothing Then aa.Select
End Sub
[quote=引用 2 楼 qq_20320947 的回复:]
有具体的区域限制把RANGE里的范围改了就不卡了,如下:
Sub Test()
Dim cel As Range, aa As Range
For Each cel In Range("A1:B10")
If cel.Interior.ColorIndex = 1 Then
If aa Is Nothing Then Set aa = cel Else Set aa = Union(aa, cel)
End If
Next
If Not aa Is Nothing Then aa.Select
End Sub
是能选择中的,除非你单元格的填充色不是纯黑色要选哪个区改ColorIndex 对应颜色的数字就行,颜色对照表和运行结果可以看图片