Hi Robert
for the entire row change
cell.interior.colorindex=3
to
cell.entirerow.interior.colorindex=3


--
Regards
Frank Kabel
Frankfurt, Germany
"Robert Couchman" schrieb im Newsbeitrag
...
Thank you for that,

but the code i need is to change the entire rows colour as
some of the cells including this may be hidden on a print
report!

anyone please help??

Robert Couchman
)