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