How can I call a macro which contains a loop but only run one iteration of that loop?

by

You a looking for something like that? 

Option Explicit

Public FromMacro As Boolean 

Sub X()

    FromMacro = True

    Call MacroX

End Sub

Sub MacroX()

    Dim Iteration As Long
    Dim i As Long

    If FromMacro = True Then
        Iteration = 1
    Else
        Iteration = 100
    End If

    For i = 1 To Iteration
        MsgBox Iteration
    Next i

    FromMacro = False

End Sub

More Related Contents:

  1. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  2. Loop through each row of a range in Excel
  3. Save excel file multiple times with file names in another workbook.
  4. Error in finding last used cell in Excel with VBA
  5. Excel VBA, getting range from an inactive sheet
  6. Is there a way to crack the password on an Excel VBA Project?
  7. How do I declare a global variable in VBA?
  8. How to use the Implements in Excel VBA
  9. How to pause for specific amount of time? (Excel/VBA)
  10. VBA code doesn’t run when cell is changed by a formula
  11. Easiest way to loop through a filtered list with VBA?
  12. What is the difference between dim and set in vba
  13. Change date format using substitute or replace
  14. Parsing an ISO8601 date/time (including TimeZone) in Excel
  15. Getting the actual usedrange
  16. Delete a row in Excel VBA
  17. VBA: Convert Text to Number
  18. How can I run VBA code each time a cell gets its value changed by a formula?
  19. How to convert 32 bit VBA code into 64 bit VBA code
  20. Referencing Excel Userform Control Name Value From String (VBA)
  21. Fill formula down till last row in column
  22. Refreshing all the pivot tables in my excel workbook with a macro
  23. Countif With Multiple OR Criteria
  24. Vlookup to copy color of a cell
  25. every possible combination of the contents of 2 columns in excel
  26. How to delete rows in Excel based on criteria using VBA?
  27. Macro to export MS Word tables to Excel sheets
  28. VBA WinHTTP to download file from password proteced https website
  29. Access files with long paths (over 260)
  30. Concatenate multiple ranges using vba

Leave a Comment