Simon Lloyd
07-30-2007, 01:51 PM
Hi all, i am trying to simply copy a shape over a range using the very simple macro below, i must admit i havent done any vba for around 2 months now so may be missing something simple, but when i run the code i get error 1004 Application - defined or object defined error!.....i cant seem to rectify it......a nudge in the right direction please!
Sub Macro2()
Dim i As Integer
For i = Range("G16") To Range("G2992") Step 12
ActiveSheet.Shapes("Oval 6990").Copy Destination:=i
Next
End Sub
Sub Macro2()
Dim i As Integer
For i = Range("G16") To Range("G2992") Step 12
ActiveSheet.Shapes("Oval 6990").Copy Destination:=i
Next
End Sub