View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B[_6_] Paul B[_6_] is offline
external usenet poster
 
Posts: 135
Default 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