Hi Everybody,

Kindly help me on solving the following requirement. I have tried the this with the this formula " IF((a1+1)<=b1,(a1+1),1)". Works fine but returns the circular reference error. So I was wondering whether VBA can do this for me in background


In my sheet , say in cell “A1” the value of the cell needs to be incremented by “1” till it equals the value of “B1”.

Cell “B1” value would be 10.

When cell “A1” value equals 10, the incremental loop needs to restart from “1” again. The incremental of values should trigger every minute.


Regards
Dilan