Select Range, Copy, Paste, FAIL! :p

[prefix]

Ok, so i've searched virtually every forum on the web, so i decided i'd post here and ask for some assistance with this seemingly easy code..

Please Login or Register  to view this content.

I'm doing this for a picture, but it simply won't paste, i've tried using Shapes as well, but to no avail. Frankly i'm stumped. It Selects the correct ranges and copies the correct picture, but it just won't paste it. Anyone have an alternative to this code?

Any help would be greatly appreciated

[prefix]

Nobody has an easy answer for this? I was hoping it was an easy command that i didn't know about :p

Excel isn't very good at handling pictures is it?

I get Error 438 Object doesn't support this property or method.

[prefix]

Ok i found it... lol

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
I've added Code tags this time.

[prefix]

Okay, sorry about that, i'll make sure to do that in the future, hopefully other people will see this and won't have to spend a day searching for a simple code.

[royUK]

Thanks for that. Does your code copy pictures larger than the single cell?

Take a look at the CpyPicture method