+ Reply to Thread
Results 1 to 5 of 5

How to store values of multiple cells in an array and paste that array data into one

  1. #1
    Registered User
    Join Date
    03-26-2021
    Location
    India
    MS-Off Ver
    2008 Build 13127.21348
    Posts
    3

    How to store values of multiple cells in an array and paste that array data into one

    Hello guys I'm new here. I joined this forum to get solutions of my VBA queries as you can see VBA is new to me.
    It'd be great if you guys help me with my VBA code.
    I'm trying to store values(strings) of some cells into and array as I have to paste all these values into one cell at the end.
    Attached Files Attached Files
    Last edited by Christina M; 03-29-2021 at 12:38 AM.

  2. #2
    Registered User
    Join Date
    03-10-2021
    Location
    Paryzevo
    MS-Off Ver
    2k3
    Posts
    60

    Re: How to store values of multiple cells in an array and paste that array data into one

    Can you attach a sample file showing the layout of the data in the sheet ?

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

    Re: How to store values of multiple cells in an array and paste that array data into one

    hi,

    this might help

    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 *

  4. #4
    Registered User
    Join Date
    03-26-2021
    Location
    India
    MS-Off Ver
    2008 Build 13127.21348
    Posts
    3

    Re: How to store values of multiple cells in an array and paste that array data into one

    Pls find the attachment in the query. I've added it just now
    Attached Files Attached Files
    Last edited by Christina M; 03-29-2021 at 12:42 AM.

  5. #5
    Registered User
    Join Date
    03-26-2021
    Location
    India
    MS-Off Ver
    2008 Build 13127.21348
    Posts
    3

    Re: How to store values of multiple cells in an array and paste that array data into one

    I've attached the sample pls check
    Attached Files Attached Files

+ 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. How to store sheetnames in an array and copy from array to summary sheet?
    By waimea in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-21-2020, 02:25 PM
  2. Replies: 1
    Last Post: 12-09-2018, 10:32 AM
  3. [SOLVED] Store the values from merged cells in an array
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2016, 11:50 AM
  4. [SOLVED] store data in memory array and then paste to sheet all at once
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2015, 03:07 PM
  5. [SOLVED] Dynamic Changing Data, Based on Criteria Store in Array, Sum array and store in Cell
    By penbeacho in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2015, 10:31 AM
  6. [SOLVED] Store Values in array
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2014, 02:07 PM
  7. How to store strings in a array and paste them in individual cells in MS ACCESS..
    By shobinp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2012, 03:36 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