Select Similar Coloured Cells in a Range
If you’d like to loop through all the cells in a sheet, it is very tempting to use something like the following:
Sub LoopThroughCells() Dim rngCell As Range For Each rngCell In Excel.ActiveSheet.Cells 'Type your code here Next rngCell End Sub