Consulting

Results 1 to 4 of 4

Thread: transferring a column from sheet to sheet with the help of button

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jun 2020
    Posts
    3
    Location

    Question transferring a column from sheet to sheet with the help of button

    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
    Last edited by Paul_Hossler; 06-28-2020 at 11:35 AM. Reason: CODE tags

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •