Hi Everyone,
I'm working on a formula to move data from one sheet to another. The code is worked when user click the button and the button is in a form. I have two sheet and I want to transfer sheet1 D2 to D18 to sheet2 E22 to E38 but the system keeps failing. I wrote down the code
sipkalem= sheet1Private Sub ComButsatınalma_yazdır_Click() With Sheets("sipkalem") Range("D2: D18").Copy Worksheets("SATINALMA FORM").Cells("E22:E38") End With End Sub
SATINALMA FORM= sheet2
Thanks for your help