Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyAndPaste Object w/namechange
Hi All...........
Is it possible to copy and paste a Drawing Object, such as a Rectangle, or whatever, and in doing the process, change the name of the Object at the same time?............sort of a "paste-as"......... Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyAndPaste Object w/namechange
Chuck,
Don't know if you consider this to be '... at the same time...' Worksheets("Sheet1").Shapes("Oval 1").Copy With Worksheets("Sheet2") .PasteSpecial Format:="MS Office Drawing Object" .Shapes(.Shapes.Count).Name = "Bob" End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All........... Is it possible to copy and paste a Drawing Object, such as a Rectangle, or whatever, and in doing the process, change the name of the Object at the same time?............sort of a "paste-as"......... Vaya con Dios, Chuck, CABGx3 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyAndPaste Object w/namechange
Thanks for the response Bob, it looks good, but I don't seem to be able to
get it to work........... I pasted it in to a Module, and tried, but just couldn't get it to run.......what did I do wrong? Sub CopyObjectRename () Worksheets("Sheet1").Shapes("Oval 1").Copy With Worksheets("Sheet2") .PasteSpecial Format:="MS Office Drawing Object" .Shapes(.Shapes.Count).Name = "Bob" End With End Sub Vaya con Dios, Chuck, CABGx3 "Bob Phillips" wrote in message ... Chuck, Don't know if you consider this to be '... at the same time...' Worksheets("Sheet1").Shapes("Oval 1").Copy With Worksheets("Sheet2") .PasteSpecial Format:="MS Office Drawing Object" .Shapes(.Shapes.Count).Name = "Bob" End With -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All........... Is it possible to copy and paste a Drawing Object, such as a Rectangle, or whatever, and in doing the process, change the name of the Object at the same time?............sort of a "paste-as"......... Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |