>Thanks, Sergey !
>
>I did not realise that the macro I was using had worksheet protection code incorporated, which was giving me errors. Afer your code initially did not work, I gave it an all-new scrutiny, and traced this problem.
>
>I used your second formula, and I am getting the result of the formula in the cell, but not the formula itself.Any way I can get the formula in the cell? Thanks !
>

Don't set the Value property. Instead, set the Formula property of the cell.

Tamar