Data Container

[miles44]

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

[6StringJazzer]

Is this a VBA question?

Please Login or Register  to view this content.

is one way

[miles44]

Yes, it's part of an Excel program

[6StringJazzer]

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]

[miles44]

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.

[Fluff13]

If you need to use an array, why not do it like

Please Login or Register  to view this content.