Select or Filter by Fill Color

[Wil]

Hi,

Does anyone know how to select a range of rows/column while they were tagged
by Fill Color?
For example,
A1 to A3, and A10 to A15 have Fill Color Green
A4 to A6, and A7 to A9 have Fill Color Red
Then, I want to filter/select only the Red and paste the values in a
different workbook.

Is there any work-around to do these or a VBA script available that somebody
can share?

Thanks in advance.

-Wilfredo

 

[CyberPhix]

Google Groups is our friend =)
Try this, its got tons of posabilities in it.

For Each cell In Selection
If cell.Interior.ColorIndex = 1 Then
[action]
End If
Next