If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macro repeat
How do you make a macro repeat over and over until you tell it to stop. In
lotus you could make it loop back on itself until you hit ctrl somehting to interupt it. I have 3000 lines in groups of 10, doing something to each of the 10, then the same thing to the next 10. Since a macro always starts in its original cell(a bug?), I need to just keep moving down, like I had it learn to move down 10 times. In this case I would have it move the 11th, and repeat itself. I don't know how to do that... -Decimal |
#2
|
|||
|
|||
Macro repeat
Not exaclty sure what you want but test this to see if if helps.
Sub doovereach10() lr = Cells(Rows.Count, "k").End(xlUp).Row For i = 1 To lr Step 10 For j = 1 To 10 Cells(i, "k").Offset(j) = i Next j Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "decimal" wrote in message ... How do you make a macro repeat over and over until you tell it to stop. In lotus you could make it loop back on itself until you hit ctrl somehting to interupt it. I have 3000 lines in groups of 10, doing something to each of the 10, then the same thing to the next 10. Since a macro always starts in its original cell(a bug?), I need to just keep moving down, like I had it learn to move down 10 times. In this case I would have it move the 11th, and repeat itself. I don't know how to do that... -Decimal |
#3
|
|||
|
|||
Macro repeat
In VBA you can use FOR loop or DO WHILE loop
see http://www.angelfire.com/biz7/julian...ans_macros.htm An example: Sub example() for i = 1 to 3000 Step 10 for j = 1 to 10 ' Do what you want to cell referenced by using i and j ' You can call a macro too by writing its name Next j Next i End Sub "decimal" wrote: How do you make a macro repeat over and over until you tell it to stop. In lotus you could make it loop back on itself until you hit ctrl somehting to interupt it. I have 3000 lines in groups of 10, doing something to each of the 10, then the same thing to the next 10. Since a macro always starts in its original cell(a bug?), I need to just keep moving down, like I had it learn to move down 10 times. In this case I would have it move the 11th, and repeat itself. I don't know how to do that... -Decimal |
Thread Tools | |
Display Modes | |
|
|