Copy picture vba code help

[prinsr]

Hee everyone,

I'm trying to write two codes:
1. to save a chart, as a bitmap, to my clipboard.
2. to save a linked picture, as a bitmap, to my clipboard.

I would like to refer to the sheet index instead of using activeschart. The funny thing is, the activechart code works, but i do not seem to get the sheet1 reference working. My code:

Please Login or Register  to view this content.

[mrice]

Try

Please Login or Register  to view this content.

[prinsr]

thanks for you help missing - i was only missing the chart property.
I thought a similar approach would work for linked pictures but unfortunately it doesn't. Can you help me finding out what I did wrong here and why there is a difference between the codes?

Please Login or Register  to view this content.

[mrice]

Try

Please Login or Register  to view this content.