Then you probably have calculation set to manual. Change it back to
automatic (Tools/Options/Calculation)


In article ,
SLP wrote:

Let me clarify a little more. When you run the code, what you see in all
rows in Column E is what the value of the formula in cell E1 is. But if you
go into each individual cell in Column E, you will see that the formula did
get copied correctly but is now showing the proper results. If you manually
enter the formula in say E3, you get the right results.