Array help
 

Trying to change these rows to green

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

but this doesnt work! Grateful for help.

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.

Array help
 

Thanks; thats how I used to do it, but I am trying to understand arrays more,
starting with basic stuff. Appreciate your help.

"JE McGimpsey" wrote:

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.

Array help
 

This is one way to use the array and color multiple rows.

Sub RwArry()
RwAry = Array(Rows(1), Rows(3), Rows(5))
For i = 0 To 2
RwAry(i).Interior.ColorIndex = 3
Next
End Sub

"General" wrote:

Thanks; thats how I used to do it, but I am trying to understand arrays more,
starting with basic stuff. Appreciate your help.

"JE McGimpsey" wrote:

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.