Hi everyone,

I require a help on replacing the result of a formula in the range E23:E77 only when the formula activecell executes.

I am using

Code\
range ("E23:E77").select
Activecell.value=Activecell.value
/code/

But, it selects the entire range and remove the formulas from each cell.
I want the macro to execute only when each cell calculates the formula.

For eg when the formula in cell E23 executes then the value should replace the formula in that cell only and not the entire range and so on for the the other cells from E23 to E77.