End (xlUp) Question

[Guzzlr]

For Each Cl In Range("C2", Range("C" & Rows.Count).End(xlUp))
   If Not IsError(Application.Match(Cl.Value, Columns(2), 0)) Then _
   Cl.EntireRow.Interior.ColorIndex = 28

The above code is working well. My question that I'm not entirely sure about, what "C2" is for?
I don't believe it to be Column 2, because that is already defined by Columns(2),0)).

Thanks for the help

 

[Dryver14]

this is saying go to the bottom of the spreadsheet in column C then come up again and select from C2 to the last used cell in column C Essencially C2:C? select

 

[Beyond_avarice]

It is a loop that uses an iteration of "C1"(not an advisable name) to walk through each cell between C2 and whatever the "Row.Count"(65k or 1 mill dependent on version of excel) up to the first cell with value in it.

If you have a match the entire row as defined in the iteration of "C1" will colored with index 28(light blue)

 

[Guzzlr]

this is saying go to the bottom of the spreadsheet in column C then come up again and select from C2 to the last used cell in column C Essencially C2:C? select

This is what I was thanking. If I use C3, the loop begins on C3?
Thanks