Thank you for all the solutions to questions others have posted. I've been able to get pretty far in VBA without having to ask any questions, simply by reading what you all have written here. So now I have problems with what should be pretty simple...
Problem: I can't seem to find an efficient way to copy and paste shapes (line and picture)using VBA. Does anyone have a good way to simplify or make more efficient the following code?
Code: obtained from running create macro-
I tried to do the following but got the error
>>>object doesn't support this property or method<<<
So clearly I've not got the syntax down.
Thanks for any suggestions
-Banyez
Problem: I can't seem to find an efficient way to copy and paste shapes (line and picture)using VBA. Does anyone have a good way to simplify or make more efficient the following code?
Code: obtained from running create macro-
Code:
ActiveSheet.Shapes.Range(Array("Line 1","Picture2")).Select
Selection.Copy
Sheets("Sheet3").Select
Cells.Select
ActiveSheet.Paste
I tried to do the following but got the error
>>>object doesn't support this property or method<<<
Code:
ActiveSheet.Shapes.Range(Array(1, 2)).Copy
So clearly I've not got the syntax down.
Thanks for any suggestions
-Banyez