Sub obj7() Dim myObject As Range Set myObject = Range("A1:B10") myObject.Interior.Color = vbRed End Sub