+ Reply to Thread
Results 1 to 8 of 8

Macro to paste data in first open row of specific range

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    Murfreesboro, TN
    MS-Off Ver
    2016
    Posts
    99

    Macro to paste data in first open row of specific range

    Hi. I need to copy 1 cell from one sheet and paste it into the first open row in a specific range.

    I have the following code that pastes what I want, but below the range. How do I specify to look for the first open row within D21:D31? (How do I change the "DRow=" line?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Macro to paste data in first open row of specific range

    Hello LKERN,

    Since I don't have a sample of your Workbook set-up, you could try;

    Please Login or Register  to view this content.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    11-08-2017
    Location
    Murfreesboro, TN
    MS-Off Ver
    2016
    Posts
    99

    Re: Macro to paste data in first open row of specific range

    Thank you for your help, Winon. Unfortunately that did not work. It immediately gave me an error.

    I am attaching a sample spreadsheet so you can see what I am trying to do.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    791

    Re: Macro to paste data in first open row of specific range

    Try replacing this line:
    Please Login or Register  to view this content.
    with this:
    Please Login or Register  to view this content.

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Macro to paste data in first open row of specific range

    Hello LKERN,

    Thank you for the sample Workbook.

    Here is your solution;

    Please Login or Register  to view this content.
    Regards
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-08-2017
    Location
    Murfreesboro, TN
    MS-Off Ver
    2016
    Posts
    99

    Re: Macro to paste data in first open row of specific range

    Thank you Winon and Akuini for your helpl! It works perfectly.

    Winon, thanks for simplifying my code as well
    Last edited by LKERN; 10-22-2019 at 09:38 AM.

  7. #7
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    791

    Re: Macro to paste data in first open row of specific range

    You're welcome, glad to help, & thanks for the feedback.

  8. #8
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Macro to paste data in first open row of specific range

    Thank you for the "Rep+", I appreciate it!

    Happy to have helped you, LKERN.

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I need macro to open a file, copy and paste everything under specific column into workbook
    By kbenjamin827 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2018, 11:59 AM
  2. VBA Macro: Copy and Paste Specific Row Range based on the Specific Value in a Cell.
    By SolidSmoke in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-10-2016, 02:40 PM
  3. Open multiple links with macro and copy specific information and paste it in excel
    By bythqire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2014, 11:08 PM
  4. open folder has multiple worksheets ,copy specific data from a tab and paste them
    By Khaled Diab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2014, 05:27 AM
  5. macro to copy range hidden paste in a specific location
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2014, 11:27 AM
  6. Replies: 0
    Last Post: 05-08-2013, 02:47 PM
  7. [SOLVED] Open specific folder, select file to open and copy then paste
    By Kranky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2012, 12:14 AM

Tags for this Thread

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