increment numbers

Hi All

I am trying to write a code in command button if i click it should give values 1 to 10 in a1 to a10
but my code gives only 10 for all cells. can you please tell whats wrong in this code

many thanx

Please Login or Register  to view this content.

Hi, grkchakri,

what about

Please Login or Register  to view this content.

You have a second loop inside the first one and only the last value is visible on these cells.

Ciao,
Holger

You have a loop within a loop
The outer loop runs from a1:a10
The inner loop runs from 1 to 10
So the final result in each cell a1:a10 will be 10 since thats the last value of the inner loop

Maybe this

Please Login or Register  to view this content.

Hi, grkchakri,

if you prefer to use the For...Each loop:

Please Login or Register  to view this content.

Ciao,
Holger

Generally, when writing to the worksheet it is better to put the answer in an array and then just write once. However, this will meet your requirement.

Please Login or Register  to view this content.

Regards,

Thank-you.jpg

Hahobe, special k