Hi Bakerman,

Thanks for the reply. It still doe not work. after running the code the cell shows blank but when I click on the cell shown 0 in the formula bar