Thread: change color and protect rows
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
  
Posts: 863
Default change color and protect rows
On Thu, 14 Oct 2004 14:59:02 -0700, Myriam
wrote:

c.Interior.Pattern = xlPatternGray50

Change that to

c.Resize(1,68).Interior.Pattern = xlPatternGray50

Reply With QuoteReply With Quote