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

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?

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

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?