Thread: Array help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Array help

One way:

Range("10:10,16:16,26:26").Interior.ColorIndex = 4


In article ,
General wrote:

Trying to change these rows to green

Rows(Array("10", "16", "26")).Interior.ColorIndex = 4

but this doesnt work! Grateful for help.