Run subs in a specific order from another macro

[tlc_in_OK]

I have 9 private subs that need to be run in a specific order. I've called them in another macro "MainMacro()" and then run them from a button. But they seem to be "firing" in random order, even though the call statements are in the order I needed them. Is there something special that needs to be done to get them to run in order?

Public Sub MainMacro()
 Call CopyPivotInfo1
 Call CopyFunctionK
 Call CopyPivotInfo2
 Call CopyFunctionL
 Call CopyPivotInfo3
 Call CopyFunctionM
 Call CopyFunctionI
 Call CopyFunctionJ
 Call Macro9
 Call ShiftCellsDownK
End Sub

 

[AD_Taylor]

Well to be honest no. As far as I've ever known they should execute in that exact order.

Do any of the macros call each other?

 

[tlc_in_OK]

No, none of them call each other. I've never seen this before either.

 

[Norie]

What do the subs do?

It's possible that whatever the end result is just appears to be caused by them running in a random order.

 

[Darren Bartrup]

All I can think is that I take it CopyPivotInfo procedures are doing something with pivot tables - could the procedures be referring to the wrong pivot tables at run time - not exactly sure how pivot table names are assigned if you don't specifically name each one. Could make it appear they're running in the incorrect order?

Hard to tell without seeing the code.

 

[tlc_in_OK]

My bad. . .you guys are correct, they DO run in exactly that order. I could run them in order and they worked perfectly, but MainMacro() will be run from a different worksheet, and I found a couple of bugs in my range references to the worksheet where the data is manipulated. Thanks for the input.