Array help

[General]

Trying to change these rows to green

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

but this doesnt work! Grateful for help.

 

[JE McGimpsey]

One way:

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

 

[General]

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

 

[JLGWhiz]

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