Hi..

I want to ask why this happen?

When I calculate for first time the number change for example
In E9 Cell =+E8*5 the value is 5 (E8 value is 1) but when I change E8 value to 2
The E9 Cell didn’t change to 10

(I want to give my printscreen but i cannot paste the picture here)

please help

thanks

Hi

One of the reasons might be the calculation is not set to automatic

It must be manual : Application.Calculation = xlCalculationManual

Instead set the calculation to automatic

with

Application.Calculation = xlCalculationAutomatic

It should give you instant results

Cheers
Shasur

http://www.vbadud.blogspot.com