ambig..name means you have two subs with the same name , when the debugger
takes you to one just rename - use find & replace to change in whole project
one at a time....



"Jwy" wrote:


I used your code and it worked fine for one range; however, I have
several ranges where I need to auto populate a cell with a date and
time stamp when another cell has data. How can I modify your code to
work with multiple cell ranges? I tried to duplicate your code and
change the cell range but received "Ambiguous Name Detected" compile
errors.

Any help is appreciated.


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