Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: Merge multiple Ranges into one Array VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #21
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merge multiple Ranges into one Array VBA

    @Peter_SSss
    I learned something very useful Thanks to your use of Cells as First Index Argument, thanks
    Trouble writing huge array into worksheet range [SOLVED] - Page 2


    @Jack Sht
    Regarding your interest in handling a large Spreadsheet the above link may also be worth a look

    Alan

  2. #22
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merge multiple Ranges into one Array VBA

    Hi again Alan!

    Thx for your response. I need an array because I want to merge lot of sheets (around 1000) into one sheet. I know that an array is a wonderful way to doy it... but construct is difficult. The idea is put all the data of each sheet in array (full), and later put it in a sheet all the data. I know do it by loops... but I don't want copy paste 1000 times. Thx for your help.

  3. #23
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merge multiple Ranges into one Array VBA

    Hi again!

    I try with Array of Arrays, and time is halved (from 40 secs to 20 secs aprox). Another way to do it? Thx.

  4. #24
    Banned user
    Join Date
    May 2014
    Location
    Germany
    Posts
    1,336
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Merge multiple Ranges into one Array VBA

    Quote Originally Posted by johnmpl View Post
    Hi again! I try with Array of Arrays, and time is halved (from 40 secs to 20 secs aprox).
    Hi again johnmpl
    Please share the codes you used, and tell us what your test data looked like
    _ ..............................

    Quote Originally Posted by johnmpl View Post
    ... Another way to do it? Thx.
    I still cannot think of a way to consolidate various ranges of data into one single Array without either some looping or using a help sheet where range data is first pasted. If No-one else can think of a way, maybe I will think of something in a couple of weeks when I may be back at my Excel Computers. ( As I said before ( Post #20 ) I am "away"just now)

    Alan

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •