OK, I followed your suggestion of renaming the new sub, but my new sub
doesn't work. I named it Worksheet_Change2, and while the compiler
doesn't blow up the code does not work.

I duplicated the original code and changed the cell range. I changed
the name of the sub as suggested to clear the ambiguous name error.
The new sub does not work. The cell to be autopopulated stays
empty...any ideas?


--
Jwy
------------------------------------------------------------------------
Jwy's Profile: http://www.excelforum.com/member.php...o&userid=27641
View this thread: http://www.excelforum.com/showthread...hreadid=354604