Ok Ok so i'm a little numb!
Sorted it, it seems because i made it in Worksheet SelectionChange i
kept starting itself because a change had been made etc.
I would like it to run automatically when a value or character i
entered in the range, right now i have assigned it to a button but it
not ideal.
Regards,
Simon
--
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=47607