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
Bookmarks