RGB Property Example

This example sets the interior color of the range A1:A10 to the chart area foreground fill color on chart one.

Worksheets(1).Range("A1:A10").Interior.Color = _
    Charts(1).ChartArea.Fill.ForeColor.RGB