put it in the sheet(s) where you want it to operate and have it as
worksheet selectionchange sub if need be define the range you want i
to work on.
HTH
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=27633