Not sure what you're after because you didn't post your code but instea
of Target.Value try this....Target.Value & Target.Address.
hope this helps
Simo
--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...nfo&userid=670
View this thread:
http://www.excelforum.com/showthread.php?threadid=27315