+ Reply to Thread
Results 1 to 5 of 5

How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA

  1. #1
    Registered User
    Join Date
    01-05-2017
    Location
    INDIA
    MS-Off Ver
    7.0
    Posts
    7

    Unhappy How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA

    Case is that:

    I have two Ranges. both are Single columned
    1- Range("A1:A10")
    2- Range ("B20:B25")

    I want to copy and paste them one after one into my bigger Range - Range("C1:C40")
    -looping not prefered-


    Any Experts to Help Me?
    Thanks,
    Last edited by fulan; 05-19-2020 at 08:50 PM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,159

    Re: How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA

    One way...
    Please Login or Register  to view this content.
    OR

    Please Login or Register  to view this content.
    Last edited by sintek; 05-18-2020 at 07:43 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    01-05-2017
    Location
    INDIA
    MS-Off Ver
    7.0
    Posts
    7

    Re: How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA

    Hi Sintek,
    Thanks for your reliable answer, it works, for me, like a charm.

    But could i ask for another solution without looping and Range.copy method.
    I am not only Curious. but I really wanted throughout my code to avoid them.
    and I wont ask for more

    Hope You will Reply Soon,

  4. #4
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,551

    Re: How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA

    If your ranges are truly fixed as you show, then this would work...
    Please Login or Register  to view this content.
    Last edited by Rick Rothstein; 05-20-2020 at 03:45 AM.

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,159

    Re: How to Copy Multiple Single Column Ranges & Paste them in a single column range - VBA

    I really wanted throughout my code to avoid them.
    I want to copy and paste them one after one
    Avoiding loops and copy in VBA coding...good luck with that lol...
    Last edited by sintek; 05-20-2020 at 05:57 AM.

+ 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. Replies: 1
    Last Post: 01-29-2020, 05:19 PM
  2. [SOLVED] Copy non-blank cells in a range and paste all into a single column
    By excellerant8 in forum Excel General
    Replies: 2
    Last Post: 05-03-2018, 10:53 AM
  3. Replies: 12
    Last Post: 03-05-2016, 03:03 PM
  4. VBA Combine Multiple Ranges Into a Single Column
    By ckthejester in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-18-2015, 10:53 AM
  5. Copy paste multiple rows into a continuing single column
    By eronbudi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2015, 11:36 AM
  6. Replies: 5
    Last Post: 05-25-2013, 07:12 AM
  7. [SOLVED] Copy column range of "single word" cells with spaces to a single c
    By nastech in forum Excel General
    Replies: 3
    Last Post: 02-15-2006, 01:10 PM

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