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