• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Run Multiple Macros in Sequence Error

D

Dokat

Member
Hi,

I have a master macro ("RunAllMacros") that executes multiple macros in sequence. However when i run it children macros returns either 0 value and doesnt return correct value. Individually I can run each children macro accurately. Did anyone come across similar issue that cause this error?

Code: 
Sub RunAllMacros()
Call Module1.CopyColumnToWorkbook
Call Module1.Vlookup
Call Module1.LookupTier
Call Module1.LookupCategory
Call Module2.ConditionalFormattingRedFE
Call Module2.SUMIFSLWFE
Call Module2.MathLWFE
Call Module2.SUMIFSL4WFE
Call Module2.SUMIFSL13WFE
Call Module2.MathL13WFE
Call Module2.SUMIFSYTDFE
Call Module2.MathYTDFE
Call Module2.SUMIFSL52WFE
Call Module2.MathL52WFE
Call Module2.SUMIFSLWBRANDFE
Call Module2.MathLWBRANDFE
Call Module2.SUMIFSL4WBRANDFE
Call Module2.MathL4WBRANDFE
Call Module2.SUMIFSL13WBRANDFE
Call Module2.MathL13WBRANDFE
Call Module2.SUMIFSYTDBRANDFE
Call Module2.MathYTDBRANDFE
Call Module2.SUMIFSL52WBRAND
Call Module2.MathL52WBRANDFE
Call Module2.SUMIFSLWFORMFE
Call Module2.MathLWFORMFE
Call Module2.SUMIFSL4WFORMFE
Call Module2.MathL4WFORMFE
Call Module2.SUMIFSL13WFORMFE
Call Module2.MathL13WFORMFE
Call Module2.SUMIFSYTDFORMFE
Call Module2.MathYTDFORMFE
Call Module2.SUMIFSL52WFORMFE
Call Module2.MathL52WFORMFE
Call Module2.SUMIFSLWFORMBRANDFE
Call Module2.MathLWFORMBRANDFE
Call Module2.SUMIFSL4WFORMBRANDFE
Call Module2.MathL4WFORMBRANDFE
Call Module2.SUMIFSL13WFORMBRANDFE
Call Module2.MathL13WFORMBRANDFE
Call Module2.SUMIFSYTDWFORMBRANDFE
Call Module2.MathLYTDFORMBRANDFE
Call Module2.SUMIFSL52WFORMBRANDFE
Call Module2.MathL52WFORMBRANDFE
Call Module2.SUMIFSLWTIERFE
Call Module2.MathLWTIERFE
Call SUMIFSL4WTIERFE
Call Module2.MathL4WTIERFE
Call Module2.SUMIFSL13WTIERFE
Call Module2.SUMIFSYTDTIERFE
Call Module2.MathYTDTIERFE
Call Module2.SUMIFSL52WTIERFE
Call Module2.MathL52WTIERFE
Call Module2.SortDataFE
Call Module3.ConditionalFormattingRedHDD
Call Module3.SUMIFSLWHDD
Call Module3.MathLWHDD
Call Module3.SUMIFSL4WHDD
Call Module3.MathL4WMANUFACTURERHDD
Call Module3.SUMIFSL13WHDD
Call Module3.MathL13WHDD
Call Module3.SUMIFSYTDHDD
Call Module3.MathYTDHDD
Call Module3.SUMIFSL52WHDD
Call Module3.MathL52WHDD
Call Module3.SUMIFSLWBRANDHDD
Call Module3.MathLWBRANDHDD
Call Module3.SUMIFSL4WBRANDHDD
Call Module3.MathL4WBRANDHDD
Call Module3.SUMIFSL13WBRANDHDD
Call Module3.MathL13WBRANDHDD
Call Module3.SUMIFSYTDBRANDHDD
Call Module3.MathYTDBRANDHDD
Call Module3.SUMIFSL52WBRANDHDD
Call Module3.MathL52WBRANDHDD
Call Module3.SUMIFSLWFORMHDD
Call Module3.MathLWFORMHDD
Call Module3.SUMIFSL4WFORMHDD
Call Module3.MathL4WFORMHDD
Call Module3.SUMIFSL13WFORMHDD
Call Module3.MathL13WFORMHDD
Call Module3.SUMIFSYTDFORMHDD
Call Module3.MathYTDFORMHDD
Call Module3.SUMIFSL52WFORMHDD
Call Module3.MathL52WFORMHDD
Call Module3.SUMIFSLWFORMBRANDHDD
Call Module3.MathLWFORMBRANDHDD
Call Module3.SUMIFSL4WFORMBRANDHDD
Call Module3.MathL4WFORMBRANDHDD
Call Module3.SUMIFSL13WFORMBRANDHDD
Call Module3.MathL13WFORMBRANDHDD
Call Module3.SUMIFSYTDWFORMBRANDHDD
Call Module3.MathLYTDFORMBRANDHDD
Call Module3.SUMIFSL52WFORMBRANDHDD
Call Module3.MathL52WFORMBRANDHDD
Call Module3.SUMIFSLWTIERHDD
Call Module3.MathLWTIERHDD
Call Module3.SUMIFSL4WTIERHDD
Call Module3.MathL4WTIERHDD
Call Module3.SUMIFSL13WTIERHDD
Call Module3.MathL13WTIERHDD
Call Module3.SUMIFSYTDTIERHDD
Call Module3.MathYTDTIERHDD
Call Module3.SUMIFSL52WTIERHDD
Call Module3.MathL52WTIERHDD
Call Module3.SortDataHDD
Call Module4.ConditionalFormattingRedAC
Call Module4.SUMIFSLWAC
Call Module4.MathLWAC
Call Module4.SUMIFSL4WAC
Call Module4.MathL4WMANUFACTURERAC
Call Module4.SUMIFSL13WAC
Call Module4.MathL13WAC
Call Module4.SUMIFSYTDAC
Call Module4.MathYTDAC
Call Module4.SUMIFSL52WAC
Call Module4.MathL52WAC
Call Module4.SUMIFSLWBRANDAC
Call Module4.MathLWBRANDAC
Call Module4.SUMIFSL4WBRANDAC
Call Module4.MathL4WBRANDAC
Call Module4.SUMIFSL13WBRANDAC
Call Module4.MathL13WBRANDAC
Call Module4.SUMIFSYTDBRANDAC
Call Module4.MathYTDBRANDAC
Call Module4.SUMIFSL52WBRANDAC
Call Module4.MathL52WBRANDAC
Call Module4.SUMIFSLWFORMAC
Call Module4.MathLWFORMAC
Call Module4.SUMIFSL4WFORMAC
Call Module4.MathL4WFORMAC
Call Module4.SUMIFSL13WFORMAC
Call Module4.MathL13WFORMAC
Call Module4.SUMIFSYTDFORMAC
Call Module4.MathYTDFORMAC
Call Module4.SUMIFSL52WFORMAC
Call Module4.MathL52WFORMAC
Call Module4.SUMIFSLWFORMBRANDAC
Call Module4.MathLWFORMBRANDAC
Call Module4.SUMIFSL4WFORMBRANDAC
Call MathL4WFORMBRANDAC
Call Module4.SUMIFSL13WFORMBRANDAC
Call Module4.MathL13WFORMBRANDAC
Call Module4.SUMIFSYTDWFORMBRANDAC
Call Module4.MathYTDFORMBRANDAC
Call Module4.SUMIFSL52WFORMBRANDAC
Call Module4.MathL52WFORMBRANDAC
Call Module4.SUMIFSLWTIERAC
Call Module4.MathLWTIERAC
Call Module4.SUMIFSL4WTIERAC
Call Module4.MathL4WTIERAC
Call Module4.SUMIFSL13WTIERAC
Call Module4.MathL13WTIERAC
Call Module4.SUMIFSYTDTIERAC
Call Module4.MathYTDTIERAC
Call Module4.SUMIFSL52WTIERAC
Call Module4.MathL52WTIERAC
Call Module4.SortDataAC
Call Module5.ConditionalFormattingRedHC
Call Module5.SUMIFSLWMANUFACTURERHC
Call Module5.MathLWMANUFACTURERHC
Call Module5.SUMIFSL4WMANUFACTURERHC
Call Module5.MathL4WMANUFACTURERHC
Call Module5.SUMIFSL13WMANUFACTURERHC
Call Module5.MathL13WMANUFACTURERHC
Call Module5.SUMIFSYTDMANUFACTURERHC
Call Module5.MathYTDMANUFACTURERHC
Call Module5.SUMIFSL52WMANUFACTURERHC
Call Module5.MathL52WMANUFACTURERHC
Call Module5.SUMIFSLWBRANDHC
Call Module5.MathLWBRANDHC
Call Module5.SUMIFSL4WBRANDHC
Call Module5.MathL4WBRANDHC
Call Module5.SUMIFSL13WBRANDHC
Call Module5.MathL13WBRANDHC
Call Module5.SUMIFSYTDBRANDHC
Call Module5.MathYTDBRANDHC
Call Module5.SUMIFSL52WBRANDHC
Call Module5.MathL52WBRANDHC
Call Module5.SUMIFSLWFORMHC
Call Module5.MathLWFORMHC
Call Module5.SUMIFSL4WFORMHC
Call Module5.MathL4WFORMHC
Call Module5.SUMIFSL13WFORMHC
Call Module5.MathL13WFORMHC
Call Module5.SUMIFSYTDFORMHC
Call Module5.MathYTDFORMHC
Call Module5.SUMIFSL52WFORMHC
Call Module5.MathL52WFORMHC
Call Module5.SUMIFSLWFORMBRANDHC
Call Module5.MathLWFORMBRANDHC
Call Module5.SUMIFSL4WFORMBRANDHC
Call Module5.MathL4WFORMBRANDHC
Call Module5.SUMIFSL13WFORMBRANDHC
Call Module5.MathL13WFORMBRANDHC
Call Module5.SUMIFSYTDWFORMBRANDHC
Call Module5.MathYTDFORMBRANDHC
Call Module5.SUMIFSL52WFORMBRANDHC
Call MathL52WFORMBRANDHC
Call Module5.SortDataHC
Call Module6.ConditionalFormattingRedINS
Call Module6.SUMIFSLWINS
Call Module6.MathLWINS
Call Module6.SUMIFSL4WINS
Call Module6.MathL4WMANUFACTURERINS
Call Module6.SUMIFSL13WINS
Call Module6.MathL13WINS
Call Module6.SUMIFSYTDINS
Call Module6.MathYTDINS
Call Module6.SUMIFSL52WINS
Call Module6.MathL52WINS
Call Module6.SUMIFSLWBRANDINS
Call Module6.MathLWBRANDINS
Call Module6.SUMIFSL4WBRANDINS
Call Module6.MathL4WBRANDINS
Call Module6.SUMIFSL13WBRANDINS
Call Module6.MathL13WBRANDINS
Call Module6.SUMIFSYTDBRANDINS
Call Module6.MathYTDBRANDINS
Call Module6.SUMIFSL52WBRANDINS
Call Module6.MathL52WBRANDINS
Call Module6.SUMIFSLWFORMINS
Call Module6.MathLWFORMINS
Call Module6.SUMIFSL4WFORMINS
Call Module6.MathL4WFORMINS
Call Module6.SUMIFSL13WFORMINS
Call Module6.MathL13WFORMINS
Call Module6.SUMIFSYTDFORMINS
Call Module6.MathYTDFORMINS
Call Module6.SUMIFSL52WFORMINS
Call Module6.MathL52WFORMINS
Call Module6.SUMIFSLWFORMBRANDINS
Call Module6.MathLWFORMBRANDINS
Call Module6.SUMIFSL4WFORMBRANDINS
Call Module6.MathL4WFORMBRANDINS
Call Module6.SUMIFSL13WFORMBRANDINS
Call Module6.MathL13WFORMBRANDINS
Call Module6.SUMIFSYTDWFORMBRAND
Call Module6.MathYTDFORMBRANDINS
Call Module6.SUMIFSL52WFORMBRANDINS
Call Module6.MathL52WFORMBRANDINS
Call Module6.SortDataINS
End Sub
 
There are a number of lines in your code that don't have a leading Modulex. part of the code

Without seeing the macro's it is difficult to understand what is wrong

I suspect that some of the macro's don't set or use the active worksheets or directories correctly

Have you stepped through them using F8 and watch what happens?
 
Hi,

No i havent stepped through them using F8. What does F8 do? I noticed part of the problem is when filters are applied in the source sheet vlookup macro doesnt work properly. What may caused that? I uploaded the test file with macros. Please see below link. Thanks

https://ufile.io/s8si9
 
In VBA click anywhere in the subroutine Sub RunAllMacros()
then press the F8 key
it starts the macro and runs one line
press F8 and it steps to the next line and executes it
repeat until you see what is wrong

If you know there is an issue in say the Module3.MathL4WTIERHDD macro
open that and select the first line
ie: the line that is Sub MathL4WTIERHDD()

press F9, it will set a break point on that line

Now go back to Sub RunAllMacros() and run it with F5
the code will run and it will stop at the line in the Module3.MathL4WTIERHDD macro
You can now use F8 to step forward as above
 
When i click on the F8 it selects the first line and then jumps to the last one in the list. It doesn't go line by line. When i individually run the macros they work fine. It's only an issue when i ran "RunAllMacros"
 
You must log in or register to reply here.
Back
Top