Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to write code to copy the objects (logos, graphics, etc) from
one sheet to another, and have them come up in the same place on the destination sheet. At the moment, it's putting them somewhere near but not quite at the top of the sheet and shifting them left a bit Is there a way to get them to go in the same place? Here's the code that isn't working: Sheets("Sheet1").Select ActiveSheet.DrawingObjects.Select Selection.Copy Sheets("Sheet2").Select ActiveSheet.PasteSpecial Format:="MS Office Drawing Object", Link:=False, _ DisplayAsIcon:=False '===================== Thanks M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Different objects-same sheet | Excel Discussion (Misc queries) | |||
Copying objects to new sheet failure | Excel Discussion (Misc queries) | |||
Copying Word OLE Object content between objects | Excel Programming | |||
Dim sheet objects | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |