i am testing the following code and get syntax error at copy line
subtest()
Set rng1=worksheets("daily crane info").Range(I7,AA15:AF15)
Set rng2=worksheets("crane wt summary").cells(rows.count,1).end(xlup)
copy rng1 Destination = rng2.offset(1,0)
end sub

this is my first try at code this involved.

thanks in advance for any assisstance, this sight is great for newbies like
me.
Rick Mason

--
Message posted via http://www.officekb.com