Hi,
Am sure this is ultra simple but how do I change the code below so it changes the colour of Rectangle: Rounded Corners 94 aswell (it's also located on Sheet2)??
Many thanks.
Am sure this is ultra simple but how do I change the code below so it changes the colour of Rectangle: Rounded Corners 94 aswell (it's also located on Sheet2)??
Many thanks.
VBA Code:
Colors = Split(Range("AO16"), ",")
With Sheet2.Shapes("Rectangle: Rounded Corners 82")
.Fill.ForeColor.RGB = RGB(Colors(0), Colors(1), Colors(2))
End With