+ Reply to Thread
Results 1 to 3 of 3

Combining multiple copy and paste ranges

  1. #1
    Registered User
    Join Date
    10-09-2019
    Location
    London, England
    MS-Off Ver
    Office 16
    Posts
    3

    Combining multiple copy and paste ranges

    Afternoon,

    Is there a quicker way to do the below? I'm copying formulas from three separate ranges, then pasting them in the same columns underneath the respective headers.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Thanks

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Combining multiple copy and paste ranges

    pasting them in the same columns underneath the respective headers.
    but it seems that next statement

    Please Login or Register  to view this content.
    is pasting formula in last row of the column ...is not it ???
    Your file included the macro will help to understand ...!
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Combining multiple copy and paste ranges

    Perhaps try .. for Range("AU1:AV1")
    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)

Similar Threads

  1. [SOLVED] Loop Copy and paste multiple ranges from multiple workbooks
    By Ravenous in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2017, 05:46 PM
  2. How to copy & paste multiple ranges by using VBA Code?
    By toradoya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2016, 07:05 PM
  3. [SOLVED] Copy/Paste Multiple Dynamic Ranges below each other
    By sudric in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-28-2015, 10:13 AM
  4. [SOLVED] Copy ranges from multiple sheets and paste them in another workbook
    By LewisM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2014, 09:26 AM
  5. Macro to copy and paste ranges multiple times
    By MGuru in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 02:16 PM
  6. Replies: 2
    Last Post: 02-14-2012, 05:52 PM
  7. Copy paste ranges from multiple sheets
    By Woody1313 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2006, 11:40 AM

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