array loop that loops through another array

Good Evening,

Can someone help me out with this one? I am trying to look for matching values from column A within column B, and if a match is found; then to bring the value of Column B + 1 column over to Column A + 1 column. The way I am trying to do this is with two arrays, where each array is representative of column A and column B. Below is what I have.

Please Login or Register  to view this content.

I'm getting an error '9', Subscript out of range error

If anyone can help me out on this, I'll greatly appreciate it. This forum has really assisted me with getting my feet wet with VBA.

Thanks,
Bob

That didn't have any affect, the error is occuring at:

Please Login or Register  to view this content.

I also changed the for loop to:

Please Login or Register  to view this content.

What I wanted to do is to use the For loop to loop through the array ranks with the variables i & h. But then, something is not translating over from the array to the i & h array bounds for that particular iteration in the loop. I'm going to try to use the "For Each" loop, but am still unsure how to pull the value out; let alone use the offset method to carry the value of the matching adjacent cell over to the other column.

Through researching this issue, I found another person with a similar problem; and one person responded by suggesting to use the .Find method. I'm going to look into that.

Range arrays are 2 dimensional, you either need to transpose or loop through the specific dimension

Please Login or Register  to view this content.

Sure, here it is.

Is there an echo in here?

Hi Norie,

After reading the response about the dimension of the array, I tried this, lol:

Please Login or Register  to view this content.

I'll go ahead and run yours. be right back.

Hey Everyone,

Thanks for all of the help. I changed the column references in the Cells object one more column over, cause that was my fault from the beginning.

I think the difference between my last attempt and Norie's suggestion is that I was trying to loop through the array by defining the dimension as the variable. But, Nories is doing the samething and taking into account the pointer variable, and using the 1 in,

Please Login or Register  to view this content.

to point to the rank...or something like that. Big ups to all.
Ah crap, also; I tried to give "Reputation" to everyone involved, but the site won't let me. Sorry.

Thanks,
Bob

Hi Mike,

Thanks for the assist. It looks like you're using a lot of methods that I'm not used to using. I'll also look into using your method.

Thanks all for the help.

bob1980