arya96
06-28-2020, 10:59 AM
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
Private Sub ComButsatınalma_yazdır_Click()
With Sheets("sipkalem")
Range("D2: D18").Copy Worksheets("SATINALMA FORM").Cells("E22:E38")
End With
End Sub
sipkalem= sheet1
SATINALMA FORM= sheet2
Thanks for your help
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
Private Sub ComButsatınalma_yazdır_Click()
With Sheets("sipkalem")
Range("D2: D18").Copy Worksheets("SATINALMA FORM").Cells("E22:E38")
End With
End Sub
sipkalem= sheet1
SATINALMA FORM= sheet2
Thanks for your help