I am cycling through x = 1 to 100. I want to say something like

For x = 1 to 100
Range("Jx").Select
Next x

so it selects J1 then J2 then J3 etc. 

How can I use a value (x) instead of hard coding 1,2,3,4,5 .....

Thank you.

macaonghus-ga:

In your specific example, you will want to use the Offset method of
the Range class. The best reference for this is the Help file in Excel
VBA, so bring up Help when you are editing your macro (hit F1 to bring
it up), and just type "Offset" in the Index Search field.

In your example, you would have:

  For x = 0 to 99

    Range("J1").Offset(x,0).Select

    <your other code goes here>

  Next x


That's all!

Regards,

aht-ga
Google Answers Researcher