Worksheet Change - need to ignore target cell in results

[zookeepertx]

Hi! That's probably a kind of confusing title, but I'll try to explain.

I have a workbook with 19 sheets in it. Twelve of them are for each month of the year and there are 2 others that need to be included in my macro ; "Add Dept" and Import & PJ".
When a user types a number into a cell in column F of one of the months' sheets, I need the Worksheet Change Event to look in the rest of column F in that sheet, as well as column F in the other monthly sheets and column E in the other 2 sheets. If the number that was just keyed is found in those other ranges, I need a message box to pop up showing all of the other cells that have that number.
I have a macro that does this, but a message box pops up even if that number isn't located anywhere else and the box shows the cell that the number was just keyed into.
I need it to not consider the "just keyed in" cell a match.

Here is the code I have now. I've studied and studied on it and tried changing NUMEROUS things and I can totally break it so it doesn't work at all (LOL!), but I can't make it do what I'm asking.

Please Login or Register  to view this content.

Also, if someone could explain to me - in non-tech terms - what each part of the bolded section does, I'd be forever in your debt! (I have an idea what some of the lines mean, but I wouldn't swear to it)

Thanks

Jenny

[stnkynts]

Please Login or Register  to view this content.

This should fix your problem

Please Login or Register  to view this content.

[zookeepertx]

Please Login or Register  to view this content.

This should fix your problem

Please Login or Register  to view this content.

Hmmm, sadly, it doesn't. The results still include the Target cell and the macro just keeps thinking and thinking and thinking until I click OK in the message box.

[stnkynts]

submit your workbook

[zookeepertx]

Okay, here it is. (On the October sheet, in the cell with the heavy border, I've placed a number that I made sure to scatter through the workbook, just so you'll have a number that will work for sure)

[stnkynts]

It worked just fine for me when I tested it on your workbook.

[zookeepertx]

It worked just fine for me when I tested it on your workbook.

I'll have to try it again next week. I'll be sure to come back and let you know how it goes. More than likely, I did something wrong; story of my life!

Thanks

Jenny