Copy Images in Excel by VBA

[samarbac]

I'm trying to paste pictures from clipboard to excel by vba macro but everytime i click the button it's keep saying "nothing to copy" - i have used snipping tool to snip something from a website and i want it to copy in the specific box in excel. Please can someone review my coding and correct me where I'm going wrong.
thanks

Please Login or Register  to view this content.

[LJMetzger]

Hi,

I'm not sure this is what you want, but the following code has been tested in Excel 2016, and works with the snipping tool. Unfortunately, working with Shapes and Pictures is not as straightforward as it should be.

Please Login or Register  to view this content.

Lewis