Chart fill format - Can it be done from Clipboard

[henkdeswardt]

Hi. I've ready many many posts on various sites, but still have not been able to find a solution.
Using Excel 2007:
I can record a macro the changes the Fill of a chart to "From Clipboard", however when I view the recorded macro there is nothing there:

Sheets("CAGED_Curve_EFF_PF_Load").Select
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveSheet.ChartObjects("Chart 1").Activate
    ActiveSheet.ChartObjects("Chart 1").Activate

(I tried it several times.)

The object is a grouping of a polygon I created (nothing too complicated.)

Is it possible to do this through VBA?

I do not want to use the import from file option.

Henk in South Africa