I'm new to VBA and need some help. Im bascially trying to say - look in column C, if the value is "State ID" then clear contents
Last = Cells(Rows.Count, "C").End(xlUp).Row
For i = Last To 1 Step -1
If (Cells(i, "C").Value) = "State ID"...