how can i select all the cells with same color on a sheet if there are multipale colors by vba code
 

how can i select all the cells with same color on a sheet if there are
multipale colors by vba code

Much better than the 1st post. try this

Sub selectyellows()
For Each cel In ActiveSheet.UsedRange
If cel.Interior.ColorIndex = 6 Then
mystr = mystr & cel.Address & ","
End If
Next cel
mystr = Left(mystr, Len(mystr) - 1)
Range(mystr).Select
End Sub

--
Don Guillett
SalesAid Software

"uobt" wrote in message
oups.com...
how can i select all the cells with same color on a sheet if there are
multipale colors by vba code