The code inserts the formula into the cell and then replaces the formula
with the value of the cell. So it works a bit like typing in the formula
and then doing a copy pastespecial values over the formula.

Regards
Rowan

shternm wrote:
Thank you - that works great.

Can you explain why that works?