Need help in creating repeat macro

You can use a For...Next loop to get a value increasing on each pass.

An example of one is

Please Login or Register  to view this content.

This would make cells A1 through A10 list the numbers of 1 through 10.

You can start a for...next from 30, so;

Please Login or Register  to view this content.

[/B]

Hi, wewillexcel,

maybe like

Please Login or Register  to view this content.

Ciao,
Holger

Originally Posted by wewillexcel

@Speshul: This would be for ordering numbers sequentially down a column, no? I am looking to do this across the top row, and not just to enter numbers but to enter something like "_V30" to "_V60" at the end of a variable name like "Apple."

To go across columns instead of rows;

For i = 1 to 10
Cells( 1, i ).value = i
Next i

Instead of

For i = 1 to 10
Cells(i, "A").value = i
Next i

The i increases by one each time, the i can be placed anywhere or mean anything as well, for example if you had an array it could be used to pick one of the array values and put it at the end of a string; MyString & MyArr(i)