Maybe the code in this could help. It will need changing for your use

http://www.excelforum.com/excel-prog...-in-value.html