for next loop in excel macros

[mikepiela]

In a excel macro I want to produce a (for next) loop around the Range / Select, statments how can this be done eg.

For x = 1 to 100 step 1
Range "A1". Select
Next x

What is the syntax need to incease the cell location A1 by 1 eg to A2, A3,...to A100 ?

Can this be done?



Regards Mike

 

[Swamp Thing]

For x = 1 to 100 step 1
Range ("A1").cells(x,1).value=x
Next x

(if you try select, it will run to fast for you to see)