Thread: [Solved] Need to repeat macro for multiple times
View Single Post
 
Old 12-07-2018, 03:31 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
What is the point of running it more than once on the same file?

You can create another macro to run a macro multiple times.
Code:
Sub DeJaVu()
  Dim i as integer
  For i = 1 to 10
    MyMacroName
  Next i
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote