"Patti" wrote in message
...
Hi Bob,

You are right that this now evaluates every row...but now it won't find
the
flag for each name unless it appears in the same row as the first instance
of the name.

So if I have in column A: Column L:

Smith blah
Smith This '( my flag)


I thought I might have messed this bit up when I moved the Found flag, but I
couldn't remember the exact requirment from your previous post. Explain what
you want again. FRom this post I read it that you want to highlight the
first row with another value in column L, but your case statement evaluates
empty as a value. If the offset value is empty would this count as found, or
should it just be This, That, etc.


I want column P of the *first* row where Smith occurs to say "I found
This!"

In my testing, this happened, as all of mine had THis, That or were empty
which i9s what the Case statement tells it to.

The use of the oCurrent variable was actually a tip I got from you, to
capture the row where I found the first instance of a new name. And of
course it works great.


Now stop that, throwing what I said back at me <VBG. If I recall, you
would use that to save the cell and then use that cell object thereafcter,
but the way you have implemented the code is to save all of the values
separately (i as the row, AgtName as the agent name), so saving the cell as
well is superfluous, not wrong, just overkill.

(sorry if I broke any rules of netiquette by staring a new thread...nearly
a
week has passed since I last posted & I thought it unlikely that the last
would be revisited).


Who cares. I personally think there is a lot of fluff about netiquette.
There are some practices that make life simpler, but they are not rules.

Anyway, I just don't understand the "why" behind it skipping a row on the
change of name. As long as I'm stuck with this problem, I am trying to
make it a good learning experience...


The why is because you had an If Else Endif. The If evaialuated the current
row, whereas the Else reset Agtname. But each case looped to the next item,
so the Else did not also go through the cell evaluation, whereas it does in
my example because it is an indecent if, before the Case evaluation.