I agree with Tom that this isn't what you wanted but it is what you
described. You chose the first value of the first column and you didn't say
that you wanted to loop through all the cells of the first column. Do you?
HTH Otto
"naterator" wrote in message
...
I'm still fairly new to programming excel but I understand basic
programming
concepts and logic. I have four arrays called stgOffers, stgOffdups,
stgClients1, stgClients2. Here's what I'm looking to do:

Layout of data -- in column b are clients and they're housed in the array
stgClients2 In column c are entries that may be duplicates. these entries
are housed in the array stgOffdups. In a separate worksheet I have a
column
with entries that are stored in stgOffers. In yet another worksheet I have
a
column with entries that are stored in stgClients1.

What to do -- I need a loop that will take the first entry of stgOffers
(call it A) and then compare each entry of stgOffdups to A. If any entry
in
stgOffdups = A then I need to compare the first entry of stgClients1 (call
it
B) to every entry in stgClients2. Now, whenever an entry of stgClients2 =
B,
I need to perform a specific action. I can code the specific action (I
think) but I can't seen to get this massive If For Next Then off the
ground.

If anyone can give me a hand I would be most appreciative. Please send me
an email at if you would like to see the code
that
I have right now.

Thanks again!
Nate