Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple macro that copies a picture object called "Pumpkin"
onto a sheet. My problem is that I would like to move the upper left corner of the picture to the upper left corner of cell 5,5. The problem I am having is how do I reference the "Pumpkin" picture that was just put on the sheet? I have many other pumpkin pictures on the sheet already so using the name "Pumpkin" is not possible. It also does not appear to be active right after the ActiveSheet.Paste that puts it on the sheet. Can you help with how I can reference this picture object just pasted on the sheet with a name that is the same as many others already on the sheet? Thanks Scott Sub Macro4() Sheets("Sheet1").Shapes("Pumpkin").Copy ActiveSheet.Paste Destination:=Worksheets("Test Traveler").Cells(5, 5) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move object with cell | Setting up and Configuration of Excel | |||
Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
Preventing users to move object in the sheet | Excel Programming |