how do i
in excel vba - i have a routine that loops through a sheet, and
highlights a single offending cell..

ActiveCell.Offset(i, C).Interior.ColorIndex = 7

i want to highlight the row, one colour and the single another colour

select offset (variable ,1) to offset(variable ,variable)?


er?

Do you mean

ActiveCell.Offset(i, C).Resize(,variable).Interior.ColorIndex = 7


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Buffyslay" wrote in message
oups.com...
how do i
in excel vba - i have a routine that loops through a sheet, and
highlights a single offending cell..

ActiveCell.Offset(i, C).Interior.ColorIndex = 7

i want to highlight the row, one colour and the single another colour

select offset (variable ,1) to offset(variable ,variable)?


er?