Hi I've been using

Dim x as DataObject
x.SetText "Mytext"
x.PutInClipboard

to place various thing in the clipboard to allow them to be easily pasted
elsewhere.

Does anyone know how to apply this to charts?

I have a worksheet containing two charts, both of which I would like to be
copied to the clipboard when a button is clicked so that they can be pasted
as a single metafile into another document.

Many thanks in advance.

Libby