Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply was to repeat a macro N times
Is there is sample way to execute a macro N number of
times without hitting a control key repeatitively? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply was to repeat a macro N times
Joe, is this what you have in mind?
Sub test_loop() Dim i As Integer i = 1 Do Until i = 12 'put code here if A1 has 1 then this will run till A1 = 12 Sheet1.[A1] = Sheet1.[A1].Value + 1 i = i + 1 Loop End Sub -- Paul B Always backup your data before trying something new Using Excel 2000 & 97 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Joe Wooldridge" wrote in message ... Is there is sample way to execute a macro N number of times without hitting a control key repeatitively? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simply was to repeat a macro N times
Write a "helper" procedu
Sub RepeatMacro() For i = 1 to 10 TheRealMacro Next i End Sub On Thu, 24 Jul 2003 19:19:03 -0700, "Joe Wooldridge" wrote: Is there is sample way to execute a macro N number of times without hitting a control key repeatitively? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeat list 5 times | Excel Discussion (Misc queries) | |||
Write a macro that enables User to simply click a button and . . . | Excel Discussion (Misc queries) | |||
Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
how do I get a calculation to repeat various number of times? | Excel Worksheet Functions |