+ Reply to Thread
Results 1 to 5 of 5

Copy/Paste Range to the bottom of a range on another worksheet using VBA

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Copy/Paste Range to the bottom of a range on another worksheet using VBA

    Hello All,

    I'm trying to copy and paste a range on one worksheet to the first row below a range on another sheet. Here is the code I tried to use but I think I'm way off. I tried modifying several things I saw here on the sight but I lack the proper understanding of writing code.

    Please Login or Register  to view this content.
    I also attached an example workbook that shows how the end result should look.

    Any help would be much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Copy/Paste Range to the bottom of a range on another worksheet using VBA

    How about...

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Copy/Paste Range to the bottom of a range on another worksheet using VBA

    It's kind of close.

    Based on your code, try this:
    Please Login or Register  to view this content.
    Based on the workheet, try this:
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Copy/Paste Range to the bottom of a range on another worksheet using VBA

    Thanks Jeff. The actual spread sheet values were in the A column. I tried to alter it to get it to work but had more success modifying Norie code. Thank you very much though. I really do appreciate you taking the time to assist me.

  5. #5
    Registered User
    Join Date
    11-19-2012
    Location
    Quantico, VA
    MS-Off Ver
    Excel 2013
    Posts
    74

    Re: Copy/Paste Range to the bottom of a range on another worksheet using VBA

    Hey Norie, The code you provided based on the worksheet worked perfectly fine. Thank you very much for your help. Now on to the rest of this workbook.

    Best Regards,

    -Troy-

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1