Subscript out of range on RGB?

[jkwleisemann]

I'm trying to set the interior color of a row, and for some reason I'm getting a "subscript out of range" error when I use the Interior.ColorIndex property. The goal is to mark Saturdays and Sundays in a chart. Code follows; any tips?

If WorksheetFunction.Weekday(datWork, 1) = 1 Or WorksheetFunction.Weekday(datWork, 1) = 7 Then
            Worksheets(4).Range(12 + i & ":" & 12 + i).Interior.ColorIndex = RGB(128, 128, 128)
        End If

 

[MrKowz]

ColorIndex doesn't support RGB. Try using .Interior.Color instead.

 

[jkwleisemann]

Thank you! Worked perfectly. Why can't the Help write-ups be this useful?

 

[Jonmo1]

Why can't the Help write-ups be this useful?

Because the help files would then be larger than the Excel Program itself.
And it would put Tech support folks out of work.

 

[MrKowz]

Thank you! Worked perfectly. Why can't the Help write-ups be this useful?

Happy to be of service. And as Jonmo1 states, it would put us helpers out of work. I kinda like it around here.