How to paste picture into cell without cell selection?

I would like to paste pictures from the clipboard to my workbook. Currently I'm using this piece of code to paste the picture, which works, however the cell need to be selected for this to work.

Please Login or Register  to view this content.

The code I want to use would start like this:

Please Login or Register  to view this content.

No, unfortunately if I run that code I get the error message "Compile error: Named argument not found." The reason for this is that Range.Pastespecial uses different arguents than Activesheet.PasteSpecial. You can see it here with inserting formatting: http://www.excelforum.com/excel-prog...tion-cell.html However I have realised that arguments are not obligatory so Range("A1").PasteSpecial actually works.

Sorry, I was working from memory, didn't actually test any code. Glad you got it to work.