Compare Range list with String Array list (both same # of values)

Hi, here is my problem.

The following code shows two separate lists of strings stored as arrays (arrOne & arrTwo). I read both arrays into a 2 dimensional array (arrDestination) and print out the results;

Please Login or Register  to view this content.

Output:

Please Login or Register  to view this content.

This works, but what I'd really like to do is store a range of values from the worksheet into the second array (arrTwo). I've tried inserting the following code lines which stores 4 values from A1 - D1;

Please Login or Register  to view this content.

The last line is replaces the previous arrTwo array. I've tried other ways of storing the range into the array, but when it comes to running the macro I either get errors with how the array is stored, or errors which seem to suggest the 2D array can not read the values.

I would also like to do a comparison on the final 2D array and output a msg stating if all rows of the 2D array match or not. Appologies if this has been covered, I did have a good look through the forum.

Would appreciate any help
Regards

You can not split myArray = Range("A1:D1").Value as you do not have a separator. You loaded a range in to an array. If you want to access the elements within the array, you need to loop through the array. Each element has an index number.

For instance.

For each arrayindex in myArray
magbox=myArray (arrayindex)

Next