| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
| Print preview moving pictures | Excel Discussion (Misc queries) | |||
| how to lock pictures from moving or being deleted in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
| Moving/deleting pictures within charts via macros | Excel Programming | |||
Linear Mode
