Thread: select offset (variable ,1) to offset(variable ,variable)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 1,726
Default 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?



Reply With QuoteReply With Quote