Pasting data in a new file acts strangely

[Irolan]

Hello everyone,

this is a bit hard to describe.
I'm currently working on a module that does the following.
A worksheet has an identifier column. All rows that contain a certain identifier (say 12345) are copied into an array. Then a new file is created and the contents of the array are pasted into the file.

Filling the array works so far, I checked it by debugging and checking the contents of the array after filling. The array is arrData(x,y).
Now, when I paste the contents of the array into the new file, I do it like this:

Please Login or Register  to view this content.

I start with A2 because the first row is the column descriptions.
Also, I don't know why I actually have to transpose the array, but it is necessasary, otherwise rows and columns are switched on paste.

The array contains 56 rows. However, instead of pasting these 56 rows, only the 11 last rows are in the new file. And they don't start at row 2, but at row 1.
Currently I assume that it pastes a few rows, then jumps back to row 1, overwrites the rows it pasted, jumps back to the top and does it until only the last 11 rows are left.

Does anyone know what's going on?

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[Kyle123]

Should be:

Please Login or Register  to view this content.

You don't need to transpose a 2 dimensional array, it's already in the format you need. I think you've also got your rows and columns mixed up (x & y), but without seeing the rest of the code I can't be sure

[Irolan]

Try this...

Please Login or Register  to view this content.

I tried that before. It does pretty much the same. The only difference is that the rows now extend all the way to [XT], with the cells from [T] to [XT] being filled with #NV.

[Irolan]

Should be:

Please Login or Register  to view this content.

You don't need to transpose a 2 dimensional array, it's already in the format you need. I think you've also got your rows and columns mixed up (x & y), but without seeing the rest of the code I can't be sure

Huh... well without transposition, rows and columns are changed, I tried that.
So... I basically fill it like

Please Login or Register  to view this content.

So basically the 2D array looks like the sheet.
If needed, I can post the entire code. Just need to take the time to translate the names and comments.

[Kyle123]

I'm not sure from the above post if your problem is solved or not.

If not, please upload a sample workbook and show us the rest of your code, there currently isn't enough to diagnose the problem:

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Irolan]

Ok, here it is. The first sheet is the data ready to be processed. Random names and numbers have been inserted.
The rightmost column (S) is the one that's important.
Sheet 1 and sheet 2 are result samples. Imagine each of them to be a separate file. What data comes in which file depends on the rightmost column.

The code is in module 1. It's probably terrible code, but I'm still very new to VBA, so my code isn't exactly elegant yet.