Hey guys,

It is my problem: I have one workbook which I wanna to copy some data and paste in another Workbook. The data is a mess, so I think the best way it is put and organize everything in a matrix, in this case: copydata(9 , 68).

copydata is declared as a public and variant, coz I have longs, integers and strings into it.

I would like to use the matrix, with its values, in other Workbook VBA Code. Then I can program the lines to paste it with my way.

As it is 680 data, I think, C&P one-by-one will take to much time and the way how it should be C&P it is a little bit hard.

Should I do the paste process to Workbook2 into a Workbook1's module?

Or is it possible to transfer the matrix between the codes?

I hope I was clear enough.

Thanks!

Heitor Tosetto