Split clipboard area of a 2D area)to an array

[mrkhchan]

Hi All,

I write the below code to get a array from the clipboard which the clipboard is from a row of excel.

Please Login or Register  to view this content.

the below is my excel file
A B C D E
row 1 1 2 3 4 5
row 2 6 7 8 9 10

for example, If i copy A1 to A5 then I run the macro. I will get A1 to A5 to an array.
myArray(0)=1;myArray(1)=2 ....
but I can't do it with A1 to B5. Even I know excel use chr(13) to split the line.
Also, if I copy A1 to A2. can I get the array be myArray(0)=1;myArray(1)=6 ?
I know I can change the code chr(9) to char(13) to do this. but the same, I can't get an area that have more than one column.

by the way, If possible, I want to put the A1 to B5 to myArray that
myArray(1,1)=a myArray(1,2)=2... myArray(2,1)=6...myArray(2,5)=10
Thanks for thinking the question.

[karedog]

Hi,

You can use the Clipboard2Array() function below :

Please Login or Register  to view this content.

Regards

[mrkhchan]

Thanks karedog. your code is perfect.

Hi,

You can use the Clipboard2Array() function below :

Please Login or Register  to view this content.

Regards

[karedog]

You are welcome mrkhchan, and many thanks for the reputation point.

Regards