Thread: Using find range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Using find range
Range("A4").Resize(1, rngcol).Interior.Color = RGB(221, 221, 221)

--
Regards,
Tom Ogilvy

"Dan" wrote in message
...
Thanks for the help. What I am looking to color, is the entire row,
columns A through whatever column rngcol is.


Reply With QuoteReply With Quote