Hi,

I have some code that works perfectly. It checks the value of each row and
colours the entire row with the appropraite colour.

For lRow = 2 To 21
If Cells(lRow, 3).Value = "Yes" Then
Rows(lRow).EntireRow.Interior.ColorIndex = 50

Next lRow


What i need is for it so only colour the row until the last column. Further
to this not all rows will have data in all fields, I think i know how to
select the last column with data in it but I need t select the last column
with data in it from any row.

I hope that makes sense.

Any help is greatly appreciated.

Martin

Next lRow