ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to run a Macro specified number of times? (https://www.excelbanter.com/excel-programming/366146-how-run-macro-specified-number-times.html)

brutonparish[_3_]

How to run a Macro specified number of times?
 

How do I write a Macro to run another Macro a certain number of times?


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile: http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557976


NickHK

How to run a Macro specified number of times?
 
Dim RunCount as Long
Const RunMax As Long=10

For RunCount =1 To RunMax
Call SecondMacro
Next

NickHK

"brutonparish"
wrote in message
...

How do I write a Macro to run another Macro a certain number of times?


--
brutonparish
------------------------------------------------------------------------
brutonparish's Profile:

http://www.excelforum.com/member.php...o&userid=35987
View this thread: http://www.excelforum.com/showthread...hreadid=557976





All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com