Thanks!!! So I am working for now....maybe it was an excel oddity!

"JLGWhiz" wrote:

I would assume that column AA is used to show if more than one change was
made. i.e. if the data in AB is different than AA then more than one change
occured. Otherwise, you only know when the last change happened.

The code is pretty simple. It checks to see if there are any entries on the
row that the target cell is on. It counts the number of entries on that row
and assigns that as the value of n. If there is only one, then it puts a
date/time entry in col AA and then posts the last change date/time stamp in
col AB.

"PatK" wrote:

Thanks...I guess we have a mystery. I did try to reset the event tracking in
the immediate window, and that did not work. I also incorporated the
recommeneded changes Gord mentions. But it seems clear based upon a debug I
put in as the very first line of code: I was not even getting to the code at
all.

So, I did this: I turned closed all excel files, cycled my computer, turned
it back on, and it is working once more. Hmmmm. So, clearly the event
"tracking" capability was turned off, and as you had noted, probably
something interrupted the code originally due to lack of error trap. Keeping
my finger's crossed that the issue is behind me.

I am somewhat unclear of what is happening logically in the code, as there
area couple of functions in it I am unfamiliar with. Your hint about what
was happening between AA and AB columns was helpful (now, I just need to
understand why you would not just write the last change to AB (instead of
first to AA, then AB)? Ie, does this mean I better leave AA and AB clear? I
know I want the timestamp in AB, but wondering about AA. Guess I will just
hide that cell and I should be ok (don't want anyone writing accidently into
a cell that this code is dependent up).

Patk

But I truly appreciate your help. Now I have to test to see if I can bust
it againl.