Auto increase in value in a cell

[rubikscube991]

I wanted to update value between 2 numbers, which would update every second and would reflect in cell A1 like (say 1 to 5)
1
2
3
4
5

once it reaches the limit it will again start from 1.

I don't want to increase number by pressing keys, it should be autoupdate.

i am pretty sure its possible, but really have no idea how to write such code, can anyone help? plz plz.. it would be really big help for me.

thanking you for your time.

Regards.
sarvesh

 

[Hui]

Pls see attached file:

Always use Reset before Start

 

[rubikscube991]

Thanks a lot hui. You are a savior like always..

thanks a ton.