View Single Post
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Leitey,

When you paste, it'll be selected.

ActiveSheet.Paste
Selection.Name = "samplepicture"
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Leitey" wrote in message
...
I want to use VBA (and maybe some variation of the ActiveSheet.Paste
command?) to paste the image on the clipboard into Excel under a certain
name
i.e. "samplepicture". I have tried "ActiveSheet.Paste.samplepicture" and
"ActiveSheet.Shapes("samplepicture").Paste" but can't seem to find a good
syntax.