I would like to know if there is a faster way for a loop to run. Here is what i have now and it is slow.
Dim rng As Range Dim lColorCounter As Long
Dim rngCell As Range
Set rng = Sheets("MASTER LINE LIST").Range("C2:Z2000")
lColorCounter = 0
For Each rngCell In rng...