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
Bookmarks