Hi,

I have a simple a operation to do:
I have a multiple buttons on sheet "DATA" and as soon as one button is clicked, I want to copy the range C:AG from the clicked line to another sheet called "TEST2".

I always get a 1004 error, It' seems to be the way I deal with the range, but I don't get it

many thanks





Sub Button_selection()

   Dim rg As Excel.Range
   Set rg = ActiveSheet.Shapes(Application.Caller).TopLeftCell
   i = rg.Row

   Sheets("TEST2").Range("C1:AG1") = Sheets("DATA").Range(Cells(i, "C"), Cells(i, "AG")).Value



End Sub