+ Reply to Thread
Results 1 to 6 of 6

Data Container

  1. #1
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Atlanta GA
    MS-Off Ver
    2010
    Posts
    106

    Data Container

    How do I set up the DIM for a container to hold 20 rows by 21 columns of data?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,285

    Re: Data Container

    Is this a VBA question?

    Please Login or Register  to view this content.
    is one way
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Atlanta GA
    MS-Off Ver
    2010
    Posts
    106

    Re: Data Container

    Yes, it's part of an Excel program

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,285

    Re: Data Container

    If my answer isn't what you need then please provide a more complete description of what you are doing along with your code.

    Ensure you use code tags. There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

    [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

  5. #5
    Forum Contributor
    Join Date
    05-04-2015
    Location
    Atlanta GA
    MS-Off Ver
    2010
    Posts
    106

    Re: Data Container

    I have a sheet that has 3 columns of data. (A1- C88) I would like to copy these three columns to E1-G88 using the following code:
    Please Login or Register  to view this content.
    Problem is, the only thing that shows in the columns E-G is the data in cell C88. This shows in each of cell, E1-G88.

    The reason I'm doing it this way is because I have another sheet in which I take data from one worksheet to another.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    14,883

    Re: Data Container

    If you need to use an array, why not do it like
    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. container show other range
    By qzlvyh0524 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2017, 05:29 PM
  2. [SOLVED] cleanse data and count the unique types of container sizes
    By jimcuk in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-08-2016, 01:43 PM
  3. Editing XML map, can't add top level container
    By abcDEF1 in forum Excel General
    Replies: 1
    Last Post: 06-13-2016, 05:03 PM
  4. Macro help to solve a minmal container calculation
    By lumeipro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2014, 04:06 PM
  5. Can't get ActiveWorkbook.Container to work
    By Ken Valenti in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2005, 01:06 PM
  6. Workbook container - can't get it to work
    By Ken Valenti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 04:06 PM
  7. worksheet container problem
    By ram_z in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2005, 06:14 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