+ Reply to Thread
Results 1 to 3 of 3

Paste Range Down to Last Row

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016
    Posts
    28

    Paste Range Down to Last Row

    Hi,

    I am trying to copy a range of cells down that has formulas in them but when recording the macro is keeps the last row pasted to. I need to make it dynamic.

    Data in columns B to H could be 10 rows long or 20 or 50. The formulas Cells I2 to O2 need to be copied to the last row used in column B and then copied ready for use elsewhere.

    The crucial bit is needs to pasting of I2 to O2 to be down to last column used in B.

    I have attached the test file.

    Hope someone can help. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    363

    Re: Paste Range Down to Last Row

    hi,

    Give this a try, copy it to the sheet code area not a module
    Please Login or Register  to view this content.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    06-27-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016
    Posts
    28

    Re: Paste Range Down to Last Row

    Thank you ,this worked nicely.

+ 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. Copy paste a static range and dynamic range excluding blanks into database
    By JobsSteve in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2020, 07:26 AM
  2. [SOLVED] Use range.copy_ destination:= ... instead of range.copy range.paste is not working. Help!
    By Halil93 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2020, 03:32 PM
  3. VBA to paste range skipping filtered rows & what is the range copy buffer called
    By foxtrotter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2020, 09:34 PM
  4. Copy range A of cells if value is in range B & paste in range B/Multiple Or
    By Jeremycad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2018, 04:28 AM
  5. [SOLVED] Find last used row in a range, paste it 1 row down, paste copied row as values
    By ExcelEnthusiast7 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-20-2018, 05:33 PM
  6. Loop through files in folder, copy range, Paste range to original workbook
    By knevil in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-09-2016, 05:33 PM
  7. [SOLVED] Help! - Copy Range (Sheet1,A10:F50), Paste Range (Sheet 2,A1:F41), Offset Range & Repeat
    By cjtimmer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 06:27 PM

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