Copy & Paste Shape Object
Copy & Paste Shape Object
(OP)
Hi,
Can anyone please help me and put me right!
I am trying to select a group of shapes in Excel, copy, paste then position them using a macro. My feable attempt below selects but does not copy and paste! I haven't got as far as positioning yet.
Set myDocument = Workbooks("K-RHS-RHS.xls").Worksheets("Brace Elastic Modulus Table")
with myDocument
With .Shapes.Range("Elements").Select
.Selection.Copy
End With
.Paste
end with
Thanks
Can anyone please help me and put me right!
I am trying to select a group of shapes in Excel, copy, paste then position them using a macro. My feable attempt below selects but does not copy and paste! I haven't got as far as positioning yet.
Set myDocument = Workbooks("K-RHS-RHS.xls").Worksheets("Brace Elastic Modulus Table")
with myDocument
With .Shapes.Range("Elements").Select
.Selection.Copy
End With
.Paste
end with
Thanks





RE: Copy & Paste Shape Object
Set myDocument = Workbooks("K-RHS-RHS.xls").Worksheets("Brace Elastic Modulus Table")
with myDocument
With Shapes.Range("Elements").Select
Selection.Copy
End With
Selection.Paste
end with
Just a thought, i'm no Excel guru
Cyril Guichard
Mechanical Engineer
RE: Copy & Paste Shape Object
RE: Copy & Paste Shape Object
Thanks MintJulep, it now positions correctly.