Numbers enter for every one second

[sathishkm]

Hi All,

I need to enter the number for example from 1 to 10000 in column A. The number should enter automatically for every second in the column.

Example:

1
2
3
4


till
10000


Thanks

[mehmetcik]

As a formula? =row()

As a Macro

Please Login or Register  to view this content.

[sathishkm]

The number should enter for every 1 second. Example after enter 1 it has to take one more second to enter 2 like so on

[modytrane]

Look at the attached file.
I created seconds counter in Cell C2.
When you click the "Start" button, you'll see seconds increasing.
When the seconds are at 1, macro will start entering 1 in "A1" and then every second it will enter next number until 10000.

Please Login or Register  to view this content.

[modytrane]

I just read your previous post again. If you want to trigger the macro based on manually entering a 1 in "A1", you can modify the macro slightly and put in Worksheet_Change event.

[modytrane]

Sorry, Seconds counter is in C3.

[modytrane]

Here's the version that works when you enter 1 in "A1".
I still have the counter in C3.

Let me know if this helps.

Please Login or Register  to view this content.

[Keebellah]

I have no idea why but I think this is what you want?
Enter 1 in A1 and the timer will start and will stop at 10000
Enter a 0 in A1 and the timer will stop.