highlighting lines in an excel macro

[rjhe22]

hi
i have this code

Please Login or Register  to view this content.

at the last part where is cal the averages and writing text to another field i want to highlight that line
how can this be done

[rjhe22]

if i add this bit of code after the looping

Please Login or Register  to view this content.

he highlight row b-e of the second last row.

i need it to highlight a-e of the last row.
any ideas why its its not doing it on last row