Moving pictures
 

Hi
Please can someone tell me if its possible to move or more specifically echo
a picture into another part of a worksheet with code, ie how do you identify
the picture you have allready pasted.
I know you can type in "Picture 1" into the dropdown goto just above A
column, but can you echo it elsewhere?
Or is there a simple add on available?
Thanks in advance
David

Moving pictures
 

Hi David,

Try:

'=============
Public Sub Tester001()
Dim myPic As Picture

With ActiveSheet
Set myPic = .Pictures("Picture 1")
myPic.Copy
.Paste Destination:=.Range("M1")
End With

End Sub
'<<=============

---
Regards,
Norman



"David Henderson" wrote in message
...
Hi
Please can someone tell me if its possible to move or more specifically
echo a picture into another part of a worksheet with code, ie how do you
identify the picture you have allready pasted.
I know you can type in "Picture 1" into the dropdown goto just above A
column, but can you echo it elsewhere?
Or is there a simple add on available?
Thanks in advance
David

Moving pictures
 

Norman
you are brilliant
thats just what I wanted
thanks a lot
David

"Norman Jones" wrote in message
...
Hi David,

Try:

'=============
Public Sub Tester001()
Dim myPic As Picture

With ActiveSheet
Set myPic = .Pictures("Picture 1")
myPic.Copy
.Paste Destination:=.Range("M1")
End With

End Sub
'<<=============

---
Regards,
Norman



"David Henderson" wrote in message
...
Hi
Please can someone tell me if its possible to move or more specifically
echo a picture into another part of a worksheet with code, ie how do you
identify the picture you have allready pasted.
I know you can type in "Picture 1" into the dropdown goto just above A
column, but can you echo it elsewhere?
Or is there a simple add on available?
Thanks in advance
David