Just stating an opinion about the cell variable name, not stating tha
it was an object or reserved word (else it wouldn't work at all).
find that the code:

For each cell in Range(R1)
Cells(cell.Row,3).Interior.ColorIndex = 33
Next

Is not as readable *to me* versus using c as the range variable.
also avoid the use of variable names like Sheeet, Applicatin, Ragne
Workbouk and other things that look like objects.

Once again, just my opinion.



--
Message posted from http://www.ExcelForum.com