Add one array to another array

Please Login or Register  to view this content.

At this point in your code, there is nothing to preserve.
vaNames is a 2D array, whereas you are only creating a 1D array.
The size of this 1D array is the size of the first dimension of vaNames plus one extra element.

Please Login or Register  to view this content.

Shouldn't this be:

Please Login or Register  to view this content.

As for the rest, it is unclear to me what you are trying to accomplish.

maybe so

Please Login or Register  to view this content.

What I was trying to do is really learn how to add a range to an array add another range of names to an array and see which of the first array matched the criteria of the second array and add that to a 3rd array and count the number in that 3rd array.

Thank you nilem.

You have given me what I wanted and I really have to study these to fully understand otherwise I am just parroting you.

By the way can you add non contiguous range to the 1st array as in

Please Login or Register  to view this content.

I can't seem to get this to work

Many thanks
Lionel

You have small ranges, so you can use Cells:

Please Login or Register  to view this content.

If you want to use arrays, it will look something like this (just for testing):

Please Login or Register  to view this content.

Hi nilem,

You are marvelous mate...

Is there any speed advantage over the cells and the array types.

I can extend the cells version ok, but the array version looks more complicated.
I have extended the cells version by quite a few not contiguous ranges so the array version is not that simple to extend.

Your thoughts

Lionel.

Arrays are processed faster, but the filling of array from cells on a worksheet (such as For each cel ... arr(i)=cel.Value) is a slow operation. I think the first code of the post #5 would be most suitable for you.

Thank you mate so are so very helpful.