+ Reply to Thread
Results 1 to 2 of 2

Dynamic Range,Find last row & paste.

  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Dynamic Range,Find last row & paste.

    I have a sheet that has a dynamic range and I need to paste copied data starting 1 row down from the last row in that range so I can continually keep adding data to this sheet.

    This is the line I am having difficultly with. And I am guessing that it is the last bit of the code that is not working. The last bit of code works fine when a hard code the range to be "B2" instead of "B" & LastRw + 1
    Note:I am copying from a dynamic range , hence the "lastRw" in the first part of the code.

    Please Login or Register  to view this content.
    LastRw is set as this code,
    Please Login or Register  to view this content.
    Cheers
    Last edited by JapanDave; 10-25-2011 at 01:38 AM.

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Dynamic Range,Find last row & paste.

    Hey guys thanks for the help, but I figured it out.

    Cheers,

    This is the answer if anyone does need this for future reference.

    Please Login or Register  to view this content.

+ 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