thanks for your code it work great can u help me on the anther code i posted it greatly appreciated http://www.excelforum.com/excel-prog...ml#post2296868